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 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] ) }
)
)

 

Help me please

1 Reply

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