Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 ?
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())
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |