Countunique with reference to another table


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).


  • 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?


Something like this maybe?

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

I tried it like this:

Unfortunately it only results in a “0”.

Do you have an idea why?


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!

1 Like


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: