DAX measure

[Anonymous]

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.

[Icey · Accepted solution]

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.

[amitchandak]

@Anonymous , Are you looking for quartiles?

https://sqldusty.com/2018/08/31/calculating-quartiles-with-dax-and-power-bi/

[Anonymous]

Hi 
Not Really.
i want the result <25% budget or >25% budget based on the quarter no. during the year.