Forum Discussion
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, 3, 4, 5? Appreciate any help.
Any chance you can provide sample data or PBIX file?
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?
11 Replies
dmoney7612 yes, if you want to keep the employee id and then in allselected include this also.
✨ 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 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.⚡
- 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)
Any chance you can provide sample data or PBIX file?
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?
Looks like this did the trick. Thank you
