Forum Discussion

Paula's avatar
Paula
Helper I
8 years ago

Rank with the same numbers

Hello! i'm having some problems whit the function RANKX.   What can i do if i have the same amount in different categories and i want to do a rank? i want to see only the top 5, but the rank 5 is 1...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Paula,

 

Which some of them do you want? Are there any other conditions? If it's possible to sort Amount in the Query Editor and add an index?

 

 

Best Regards,

Dale

Paula's avatar
Paula
Helper I
8 years ago

Hi v-jiascu-msft

 

I have no preference. If I add an index, can I choose one of the categories and obtain the top 5? In case of adding an index, what would the DAX be like?

 

There is no other condition.