Forum Discussion
Counting Products based on Indicator
hi pbi_girl_21
You can use these Measures.
Fruit Count =VAR _FruitCount = CALCULATE(DISTINCTCOUNT(Fruits[Product]), Fruits[Fruit Indicator] = 1)RETURN IF( ISBLANK(_FruitCount), 0 , _FruitCount)Fruits =VAR _FruitCount = [Fruit Count]RETURN IF(_FruitCount = 1, CALCULATE( VALUES(Fruits[Product]), Fruits[Fruit Indicator] = 1) , BLANK())You can also show all the fruits in a Store if that is the requirement.
Hi pbi_girl_21
Try use filters to filter your unique fruit count field
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you, this works for isolating Store B.
But it also made me realize I forgot to ask a part of my question. The next step I want to do is to be able to isolate for examples like the strawberry in Store A. Specifically, if a fruit is the only unique fruit for a store, how can I identify it? Filtering for 1 in the example above doesn't seem to work for me, it only gives me blank results.
Hi pbi_girl_21
Please try what I did in the screenshot.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.