Forum Discussion

Ani26's avatar
Ani26
Helper 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
Super User
4 years ago

Ani26 read this post to get ranked by category and subcategory and the same applies in your situation. How to use RANKX in DAX (Part 2 of 3 – Calculated Measures) - RADACAD

 

✨ 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!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • Ani26's avatar
    Ani26
    Helper III
    4 years ago

    Hi parry2k 
    Thank you for providing the link. I went through the link provided by you but in that the DAX measures are created for fields coming from the same table whereas in my case  I am pulling fields from different dimension tables and measure values from Fact table.