Forum Discussion

dmoney7612's avatar
dmoney7612
Icon for Helper II rankHelper II
4 years ago
Solved

Need help with ranking expression

I am trying to create a ranking expression based on average daily sales growth for my account managers. As you can see in the below image, it is not working correctly. The expression I'm using is the...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi dmoney7612 ,

     

    You can refer to this article about ranking in power bi.

    Since there is no data model, it is suggested to try

    Pref Supplier Rank = 
RANKX (ALLSELECTED('EC Hierarchy'),[ADS % Growth],,ASC,Dense)

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

dmoney7612 check this post and fix the DAX measure accordingly. it is well explained and should solve your issue.

 

✨ Follow us on LinkedIn

 

Check 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.⚡

  • dmoney7612's avatar
    dmoney7612
    Icon for Helper II rankHelper II
    4 years ago

    parry2k Appreciate the resource but I am still having issues because the ADS % Growth that I want ranked is already a calculated measure, and therefore does not populate when using the CALCULATE(SUM( expression. I can't seem to find a workaround.