Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Aleksandra_MLT
Advocate I
Advocate I

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. Segments.PNG

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

 

1 REPLY 1
community_pinki
Helper II
Helper II

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.