Forum Discussion
Rankx measure Problem
Hi anyone,
Please help to fix my problem,
I have data something like this,
and i want to compute rank based on EBIT data per msc,
instead of computed by msc, the rank goes by desc (GL desc),
how to go beyond the desc for the rank based on Total EBIT per msc
so the rank should be "1" all the way down.
here is the measure that i use:
Hi Teukuario
When using the RANKX measure you need to use the CALCULATE for the value you want to have ranked in this case try to redo your measure to:
Rank = RANKX(ALL(TowerMaster[msc]),CALCULATE([Total EBIT]),,DESC)Check this blog post with a complete explanation of the why of the use of calculate within this function.
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
2 Replies
- MFelix
Super User
Hi Teukuario
When using the RANKX measure you need to use the CALCULATE for the value you want to have ranked in this case try to redo your measure to:
Rank = RANKX(ALL(TowerMaster[msc]),CALCULATE([Total EBIT]),,DESC)Check this blog post with a complete explanation of the why of the use of calculate within this function.
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
v-xiaotangCommunity Support
Hi Teukuario
Could you provide some information? Thanks.
(1) a sample file, you can replace raw data with bogus data to protect your privacy.
or provide some sample data that fully covers your issue/question.
(2) give your expected result and its math formula based on the sample you provide.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.