Forum Discussion
dmoney7612
Helper II
Helper IINeed 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...
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
Super User
Super Userdmoney7612 that reply is not very helpful 😃
Maybe easier share pbix file with sample data and explain what you are looking for and let's go from there.
dmoney7612Helper II
Helper IIIt says pbix is not supported when I try to drag the file in