Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamic measure with WHAT-IF parameters

Hey!  I need to have dynamic segments ( High performers, Medium performers, Low performers and Passives ) based on number of items sold so the customer could adapt the value for each segment and the...
Help me please
community_pinki's avatar
community_pinki
Icon for Helper II rankHelper II
5 years ago

Hi Anonymous ,

Could you please try this

Step 1:- Create a measure to calculate Grand Total like
Grand Total for High Performance = Calculate([Grand total], High performers[High performers] IN {VALUES ('High performers'[High performers])})


Step 2 :- Also create a same measure for Medium Performers, Low Performers and Passive.


Step 3 :- SelectedMeasure = SWITCH(TRUE(),
SELECTEDVALUE( 'High performers'[High performers]),[Grand Total for High Performers],
SELECTEDVALUE('Medium performers'[Medium performers]),[Grand Total for Medium Performers],
BLANK())