Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to Count Unique Customers Based on Only Having Specific Values

Hello,   I'm new to Power BI and can't wrap my head around this. I attached a sample table closely related to what I'm trying to figure out.   Table1 Customer Name Food Group Aaron Fruit...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Dowload my PBI file from here.

    Hope this helps.

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
4 years ago

Anonymous 

you can try this

Measure = DISTINCTCOUNT('Table'[Customer Name])- CALCULATE(DISTINCTCOUNT('Table'[Customer Name]),FILTER('Table','Table'[Food Group]="Meat"))
 
Measure 2 =
VAR TBL=DISTINCT(FILTER('Table','Table'[Food Group]="Meat"))
VAR tbl2=ADDCOLUMNS(TBL,"CHECK",CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Customer Name]=[Customer Name])))
RETURN COUNTROWS(FILTER(tbl2,[CHECK]<>1))