Forum Discussion
alevandenes
Helper IV
5 years agoMatch and count categories
Hi community, I have a problem that i dont know how to approach. I hope you can help me out with solving it. I would like for a count to be set up when specific characteristics are matched. in ...
- 5 years ago
Hi alevandenes,
Try this measure:
Match Count = VAR vProduct = MAX ( Orders[Product] ) VAR vColour = MAX ( Orders[Colour] ) VAR vSize = MAX ( Orders[size] ) VAR vTable = FILTER ( ALLSELECTED ( Orders ), Orders[Product] = vProduct && Orders[Colour] = vColour && Orders[size] = vSize ) VAR vResult = COUNTROWS ( vTable ) RETURN vResult
Ashish_Mathur
Super User
5 years agoHi,
A simple solution would be to create a calculated column formula to concatenate product, colour and size. Then write a measure to do a distincount of the entries in the new column.
Hope this helps.