Forum Discussion
dmoney7612
4 years agoHelper II
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...
- Anonymous4 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
4 years agoSuper User
dmoney7612 let's do one step at a time. Did rank work out? I think that was your original question. If yes, it worked out, what else do you want to achieve?
- dmoney76124 years agoHelper II
Not much is working right now