Forum Discussion

dmoney7612's avatar
dmoney7612
Helper II
4 years ago
Solved

RankX formula question

I am trying to rank sales leaders based on their average daily sales growth rate. The expression I am using seems to work, but any reason why the rankings would be arbitrary numbers instead of 1, 2, ...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Any chance you can provide sample data or PBIX file?

  • parry2k's avatar
    parry2k
    4 years ago

    dmoney7612 what is Employee Id, can you remove that from the visual and check if it works, maybe it is passing the row filter context to the measure?

parry2k's avatar
parry2k
Super User
4 years ago

dmoney7612 in allselected give the column name of the leader

 

ALLSELECTED ( YourTable[LeaderColumnName] )

 

✨ Follow us on LinkedIn

 

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

 

dmoney7612's avatar
dmoney7612
Helper II
4 years ago
Now each ranking appears as "1". Are there any other tweaks needed to the expression?
 
Leader ranking = RANKX (ALLSELECTED('EC Hierarchy'[VP]),[ADS % Growth],,DESC,Dense)
  • dmoney7612's avatar
    dmoney7612
    Helper II
    4 years ago

    parry2k any additional insight here? Here is how it currently looks:

     

     

    • PaulDBrown's avatar
      PaulDBrown
      Community Champion
      4 years ago

      Reference the main fact table column in the ALLSELECTED instead of the Hierarchy table column

      • dmoney7612's avatar
        dmoney7612
        Helper II
        4 years ago

        Main fact table?