Forum Discussion
DAX measure
I have created a table visual and I want to see the classification change as the slicer is being modified.
For example
| Actual Utilisation rate | Utilisation classification |
| 10 | <25% budget |
| 26 | >25% budget |
Quarter 1 is 25%
Quarter 2 is 50%
Quarter 3 is 75%
Quarter 4 is 100%
If only one quarter is selected, it should show 25%actual utilisation will be culmulative, and the classification should automatically show 50% if both Q1 & Q2 are selected. Q1, Q2, Q3 are selected ,75% should appear.
This goes on for the other quarters too.
Can you please help on how to do that?
Thank you.
Hi Anonymous ,
Do you mean something like this?
Measure = VAR Count_SelectedQuar = COUNTROWS ( VALUES ( 'Table'[Quarter] ) ) RETURN SWITCH ( Count_SelectedQuar, 1, 0.25, 2, 0.50, 3, 0.75, 1.00 )Or,
Measure = VAR Count_SelectedQuar = COUNTROWS ( VALUES ( 'Table'[Quarter] ) ) RETURN SWITCH ( Count_SelectedQuar, 1, "25%", 2, "50%", 3, "75%", "100%" )Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
Anonymous , Are you looking for quartiles?
https://sqldusty.com/2018/08/31/calculating-quartiles-with-dax-and-power-bi/
- Icey
Community Support
Hi Anonymous ,
Do you mean something like this?
Measure = VAR Count_SelectedQuar = COUNTROWS ( VALUES ( 'Table'[Quarter] ) ) RETURN SWITCH ( Count_SelectedQuar, 1, 0.25, 2, 0.50, 3, 0.75, 1.00 )Or,
Measure = VAR Count_SelectedQuar = COUNTROWS ( VALUES ( 'Table'[Quarter] ) ) RETURN SWITCH ( Count_SelectedQuar, 1, "25%", 2, "50%", 3, "75%", "100%" )Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
