topic Re: DAX measure in DAX Commands and Tips

DAX measure

Anonymous — Mon, 30 May 2022 06:30:14 GMT

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.

Re: DAX measure

amitchandak — Mon, 30 May 2022 09:33:37 GMT

Anonymous , Are you looking for quartiles?

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

Re: DAX measure

Anonymous — Mon, 30 May 2022 10:51:56 GMT

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

Re: DAX measure

Icey — Thu, 02 Jun 2022 06:06:07 GMT

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.