Forum Discussion

Frequent Visitor

5 years ago

Distinct Count [NOT IN]

Hi Community I need help with dax I have a table with IDs and Category: ID Category 1 A 2 B 3 C 4 D 5 A 5 B 5 C 6 A 6 C 7 B 7 C 8 A 8 ...

Helper III

5 years ago

count in B Measure =

VAR __As = DISTINCT(SELECTCOLUMNS(FILTER('Table',[category]="A"),"ID",[ID]))

VAR __Bs = DISTINCT(SELECTCOLUMNS(FILTER('Table',[category]="B"),"ID",[ID]))

RETURN

COUNTROWS(DISTINCT(EXCEPT(__Bs,__As)))

Thanks

Frequent Visitor

5 years ago

sqlguru448 , no luck buddy