Forum Discussion

arb1782's avatar
arb1782
Helper III
5 years ago

Help with calculation - count IDs except IDs in another table

Hi   I have data like this and I want to count the number of IDs in table 1 minus those that are mentioned at least once in table 2. Could anyone help me with the right DAX? With the example data b...
Need Help
AlB's avatar
AlB
Community Champion
5 years ago

Hi arb1782 

Place this measure in a card visual

 

Measure =
COUNTROWS(EXCEPT(DISTINCT(Table1[ID]), DISTINCT(Table2[ID])))

 

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers