Forum Discussion
RANKX weird behaviour
Hi all, hope you are doing good. I started using the RANKX function but I'm having a strange scenario that my limited knowledge of DAX cannot explain.
Here is the file in Google Drive (let me know if you can download it):
The problem is with the measure [Rank overall]. Is not showing the overall rank starting from 1. It is starting from another number. I need it to start from 1, then 2, 3, etc.. based on the measure [IPK] to rank.
The measure [Rank by subcategory] works perfectly. :smileyhappy:
[Rank overall] = Rank overall = RANKX( ALL(IPKR); CALCULATE([IPK]); ; DESC; Skip)
Any doubt please let me know. Thank you very much in advance!
Kind regards,
Andy
Modify the measure [IPK], [Rank overall]
IPK2 =
DIVIDE (
CALCULATE ( SUM ( IPKR[Pasajeros] ), ALLEXCEPT ( IPKR, IPKR[Ramal] ) ),
CALCULATE ( SUM ( IPKR[Kilómetros] ), ALLEXCEPT ( IPKR, IPKR[Ramal] ) ),
0
)
Rank overall = RANKX(
ALLSELECTED(IPKR),
IPKR[IPK2], , DESC, Dense
)Best Regards
Maggie
4 Replies
Where is the measure [Rank overall]? From your pbix, I can't see it.
Does the "Ranking" refer to the measure [Rank overall], if so, what's the matter with the rank number, what is the correct rank, could you give an example?
Best Regards
Maggie
Hi Maggie, my bad, I uploaded the wrong file... I fixed the link. Please give it a new try!
Thanks for your help :)
Regards,
Andy
Modify the measure [IPK], [Rank overall]
IPK2 =
DIVIDE (
CALCULATE ( SUM ( IPKR[Pasajeros] ), ALLEXCEPT ( IPKR, IPKR[Ramal] ) ),
CALCULATE ( SUM ( IPKR[Kilómetros] ), ALLEXCEPT ( IPKR, IPKR[Ramal] ) ),
0
)
Rank overall = RANKX(
ALLSELECTED(IPKR),
IPKR[IPK2], , DESC, Dense
)Best Regards
Maggie
