How to Count Unique Customers Based on Only Having Specific Values

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))

Hi,

please check the below picture and the attached pbix file.

Question one measure: = 
VAR newtable =
    SUMMARIZE (
        FILTER ( Data, Data[Food Group] IN { "Fruit", "Vegetable" } ),
        Data[Customer Name]
    )
VAR othertable =
    SUMMARIZE (
        FILTER ( Data, Data[Food Group] IN { "Meat" } ),
        Data[Customer Name]
    )
VAR resulttable =
    EXCEPT ( newtable, othertable )
RETURN
    CONCATENATEX ( resulttable, Data[Customer Name], ", " ) & " / "
        & COUNTROWS ( resulttable )

Question two measure: = 
VAR newtable =
    SUMMARIZE (
        FILTER ( Data, Data[Food Group] IN { "Fruit", "Vegetable" } ),
        Data[Customer Name]
    )
VAR othertable =
    SUMMARIZE (
        FILTER ( Data, Data[Food Group] IN { "Meat" } ),
        Data[Customer Name]
    )
VAR resulttable =
    INTERSECT( newtable, othertable )
RETURN
    CONCATENATEX ( resulttable, Data[Customer Name], ", " ) & " / "
        & COUNTROWS ( resulttable )

Hi,

You may download my PBI file from here.

Hope this helps.

Hello all,

I tried all of your solutions to my real dataset but the second measure for counting a food group that is meat and either fruit or vegetable or both doesn't account for a customer that has 2 or more of each. For example,

Table1

In this updated table, George, Isabel and Joe should be considered in the second measure.

Also, since there is a total of 11 unique customers and Heather and Kevin doesn't fit in either measures, (1st measure has Aaron, Bill, Derek, Eric {4 total}), (2nd measure has Chris, Francine, George, Isabel, Joe {5 total}, is it correct to assume that the difference between the total unique customers and sum of both the measures is the total number of customers that only have a food group of meat, which is 2 in this case (Heather, Kevin)?

In my real dataset, it is substantially bigger, so the difference isn't clearer to me if I could make that assumption.

Thank you!