Thought it would be easy with a sample pbix file.
What I want to do is to rank [Item ID] as per [Display Margin] from hightest to lowest. The ranking should also able to adjust as per the filters used.
Sample file: https://ucliveac-my.sharepoint.com/:u:/g/personal/pwa92_uclive_ac_nz/EWVxnbjgEVhAqvi2NuX_85cBOYz803u...
Thanks very much!
Go to Solution.
Hi @Penn ,
If you mean you want to ranking multiple columns, you can refer to following link to use countrows and isonorafter function to achieve your requirement:
Rank by Quarters
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!