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

parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

Ani26 you keep on referring me smpa01  which is cool. Hmm, very hard to tell what is going on. Can you create dummy pbix file and send me via email, my email is in my signature.

 

✨ Follow us on LinkedIn and  to our YouTube channel

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

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

Ohh God.
My sincere apologies parry2k. Extremely sorry for that.
I will try to replicate the issue in a sample pbix and will send it to you over email.