cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AndresSalomon Regular Visitor
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): 

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. Smiley Happy

 

[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
Highlighted
Community Support Team
Community Support Team

Re: RANKX weird behaviour

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
)

1.png

 

Best Regards

Maggie

 

4 REPLIES 4
Community Support Team
Community Support Team

Re: RANKX weird behaviour

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 Regular Visitor
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 Smiley Happy 

 

Regards,

Andy

Highlighted
Community Support Team
Community Support Team

Re: RANKX weird behaviour

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
)

1.png

 

Best Regards

Maggie

 

AndresSalomon Regular Visitor
Regular Visitor

Re: RANKX weird behaviour

Awesome Maggie! @v-juanli-msft

Thank you very much!! Smiley Happy

 

Kind regards,

Andy