topic Median of growth in DAX Commands and Tips

Median of growth

Sscb — Mon, 03 Jul 2023 21:27:14 GMT

I have created a measure for yoy sales growth brand wise.

Now from this measure i want to create another measure which will categorise each brand as high Based on the condition that if it's yoy growth is greater than median yoy growth of all brands, else it should be low

Note: data is at order level

Can anyone please guide me through this

I have written a daxc but i am not so confident about it-

Mediangrowth=medianx(table, table[growth]

Category=if(table[growth]>mediangrowth, high, low)

Re: Median of growth

Anonymous — Tue, 04 Jul 2023 06:46:28 GMT

Hi Sscb ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data.

(2) We can create calculated columns.

Mediangrowth = MEDIANX('Table','Table'[growth])

Category = IF('Table'[growth]>'Table'[Mediangrowth],"high","low")

(3) We can create measures.

Measure_Mediangrowth = MEDIANX(ALL('Table'),'Table'[growth])

Measure_Category = IF(MAX('Table'[growth])>[Measure_Mediangrowth] ,"high","low")

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.

Re: Median of growth

Sscb — Tue, 04 Jul 2023 09:34:04 GMT

Hi Anonymous

Thanks for the response

So the thing is growth is also a measure, which is yoy growth.

Will this work there as well?

Re: Median of growth

Anonymous — Wed, 05 Jul 2023 02:58:18 GMT

Hi Sscb ,

Try it.

Measure_Mediangrowth = MEDIANX(ALL('Table'),'Table'[growth])

Measure_Category = IF('Table'[growth]>[Measure_Mediangrowth] ,"high","low")

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.