Dynamic measure with WHAT-IF parameters

[Aleksandra_MLT]

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 these would reflect on a visual (could be any type).

For example: we sell items to various companies and depending on count we would need to classify customers.

So far I created 2 What-if parameters and slicers and not sure how to go further. 

I was trying with this measutre but it gives me nothing 🙂 any suggestions ?

Performance segments =

IF (

SELECTEDVALUE ( 'High performers'[High performers] ),

[(grand total)] IN { VALUES ( 'High performers'[High performers] ) },

IF (

SELECTEDVALUE ( 'Medium performers'[Medium performers] ),

[(grand total)] IN { VALUES ( 'Medium performers'[Medium performers] ) }

)

)

[community_pinki]

Hi @Aleksandra_MLT ,

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())