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

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

Ani26  can you please create  a sample pbix and provide here?

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

Hi smpa01 
My sincere apologies but I am not getting the option to attach a pbix here. Since this been an organization system I don't have access to save it on a drive and provide the link.