cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Penn Regular Visitor
Regular Visitor

DAX ranking question with a sample pbix file

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.

 

Annotation 2019-05-17 170444.jpg

 

Sample file: https://ucliveac-my.sharepoint.com/:u:/g/personal/pwa92_uclive_ac_nz/EWVxnbjgEVhAqvi2NuX_85cBOYz803u...

 

Thanks very much!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: DAX ranking question with a sample pbix file

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
1 REPLY 1
Community Support Team
Community Support Team

Re: DAX ranking question with a sample pbix file

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |