Forum Discussion
alevandenes
Helper IV
Helper IVMatch 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 ...
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
DataInsights
Super User
Super UserHi 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