Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

different outputs inside a calculated column using SWITCH()

hey,   im not new to powerbi or dax at all but im trying to achive someting and for the love of god im trying but always failing   the demand is:   i have a table:   (its distinct so we...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , You can try measure like

Measure =
VAR _tab = allselected('Organization Hierarchy'[Region])
RETURN
CALCULATE(count('Item Category New'[Value]),filter('Item Category New', 'Item Category New'[Attribute] in _tab))

 

you can plot

'Item Category New'[Value]