Forum Discussion
Classify customer based items purchased
I'd like to be able to classify, and then filter customers in a report based on what they purchased. My customer criteria is: 1. if a customer has only purchased Standard products, then they are a "...
Anonymous ,
In such a case better to make it as the column, find the attached file.
Appreciate your Kudos.
amitchandak
Super User
Super UserAnonymous ,
try all 4 as measures
all= calculate(distinctCOUNT(table[Product Bought]))
Standard =calculate(distinctCOUNT(table[Product Bought]), Product Bought="Standard")
Classic =calculate(distinctCOUNT(table[Product Bought]), Product Bought="Classic")
flag =
Switch(true(),
[all]=[Standard],"Standard",
[all]=[Classic],"Classic",
"Both"
)
Appreciate your Kudos.