Forum Discussion

RK9009's avatar
RK9009
Frequent Visitor
6 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 ...
sqlguru448's avatar
sqlguru448
Icon for Helper III rankHelper III
6 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
  • RK9009's avatar
    RK9009
    Frequent Visitor
    6 years ago

    sqlguru448 ,  no luck buddy