Forum Discussion

Penn's avatar
Penn
Icon for Resolver I rankResolver I
7 years ago
Solved

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.

 

 

Sample file: https://ucliveac-my.sharepoint.com/:u:/g/personal/pwa92_uclive_ac_nz/EWVxnbjgEVhAqvi2NuX_85cBOYz803uMkKW22n3I2Yw85g?e=JU8ZXP

 

Thanks very much!

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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