Forum Discussion

Ani26's avatar
Ani26
Icon for Helper III rankHelper III
4 years ago
Solved

RANKX function not giving correct results

Hi Team, Wish you all a very happy new year !! Need your help today with one of the requirement. We have a data model in Power BI with one fact and few dimensions. The requirement is we are pull...
Need Help
  • Ani26's avatar
    Ani26
    4 years ago

    Hi All,

    Sorry for a delayed reply. 
    I got this resolved. Actually the issue was Column Region had a sort by on it by another column which was actually causing the ranking to give incorrect results. As soon as I removed the sorting by another column, the DAX formula (in the description) gave me the correct results.

    parry2k  and smpa01 thank you so much for help and assistance.

     

    Thanks.
    Ani

Ani26's avatar
Ani26
Icon for Helper III rankHelper III
4 years ago

Hi All,

Sorry for a delayed reply. 
I got this resolved. Actually the issue was Column Region had a sort by on it by another column which was actually causing the ranking to give incorrect results. As soon as I removed the sorting by another column, the DAX formula (in the description) gave me the correct results.

parry2k  and smpa01 thank you so much for help and assistance.

 

Thanks.
Ani