Forum Discussion

RK9009's avatar
RK9009
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 ...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

RK9009 Try:

Count in B Measure =
  VAR __As = DISTINCT(SELECTCOLUMNS(FILTER('Table',[Category]="A"),"ID",[ID]))
  VAR __Bs = DISTINCT(SELECTCOLUMNS(FILTER('Table',[Category]="A"),"ID",[ID]))
RETURN
  COUNTROWS(DISTINCT(EXCEPT(__Bs,As)))
RK9009's avatar
RK9009
Frequent Visitor
5 years ago

Greg_Deckler , Thank you for the response, I tried this measure but no luck