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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.