RANKX weird behaviour

[AndresSalomon]

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

Link to report

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. 

[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

[v-juanli-msft]

Hi @AndresSalomon

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

[AndresSalomon]

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

[v-juanli-msft · Accepted solution]

Hi @AndresSalomon

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

[AndresSalomon]

Awesome Maggie! @v-juanli-msft

Thank you very much!! 

Kind regards,

Andy