Countunique with reference to another table

[Thomas_Meissner]

Hi,

currently I build a skill tracker to keep an overview, who learned what in my team.

The core table looks like this:

I use some extra tables for reporting. One of them looks like this:

In the 2nd table I would like calculate the “agents trained” column. Here I would summarize, how many agents have been listed for each topics (so unique name counts).

e.g.:

• Logistics: 6 people
• Security: 3 people

Why unique?
Every agents has several skills to be trained on and has several rows within a topic with his name listed in the core table.

I tried this formula:
[Complete Data Base].Filter([Complete Data Base].Topic= thisRow.Topic).Countunique([Complete Data Base].Name)

But it only shows all unique agents in every row… The Topic filter does not impact the result here.

Any idea on how to solve this problem?

[Ander]

@Thomas_Meissner

Something like this maybe?

[complete db].Filter(topic=thisRow).name.CountUnique()

[Thomas_Meissner]

@Ander
I tried it like this:

Unfortunately it only results in a “0”.

Do you have an idea why?

[Thomas_Meissner]

Ah,

I found two mistakes…
1.) In table 2 Topic was not a select list like in table 1.
2.) Instead of “this row” I needed to enter “Topic” from table 2. Then it worked.

Thanks for your help!

[Ander]

@Thomas_Meissner

EDIT: I was just about to post when I saw your update. I’ll leave this here as a visual aid for others.

---

It looks like there are one or more data type mismatches. Compare the data types indicated by your formula tokens, to those in the embedded doc: