cancel
Showing results for
Did you mean:
Regular Visitor

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.

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

Re: RANKX weird behaviour

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 4
Community Support Team

Re: RANKX weird behaviour

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

Regular Visitor

Re: RANKX weird behaviour

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

Community Support Team

Re: RANKX weird behaviour

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

Highlighted
Regular Visitor

Re: RANKX weird behaviour

Awesome Maggie! @v-juanli-msft

Thank you very much!!

Kind regards,

Andy