Rankx measure Problem

[Teukuario]

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:

Rank =

RANKX(ALL(TowerMaster[msc]),[Total EBIT],,DESC)

Thank you,

Best Regards

[v-xiaotang]

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.

[MFelix · Accepted solution]

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