Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Everyone,
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!
Solved! 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:
Regards,
Xiaoxin Sheng
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:
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |