DAX ranking question with a sample pbix file

[Penn]

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!

[Anonymous · Accepted 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

Regards,

Xiaoxin Sheng