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
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
