Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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:
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |