Forum Discussion
Market share by different Packs/subsegments
Hi Gurus I am a POWER BI newbie.. and I am stuck with something rather dumb..... I have a example dataset like below Market Brand Pack Value Sales Time X A Small 100 Q1'20 ...
amitchandak
Super User
Super UserAnonymous , You might have to create two measures and switch using isinscope
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
similar example
IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM
ValShare pack size=
DIVIDE (
SUM ( MAINTABLE[Value SALES)] ),
CALCULATE ( SUM ( MAINTABLE[Value sales ] ), ALL ( MAINTABLE[Pack Size] ) )
) *100