Forum Discussion
Solved
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 kn...
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
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