Forum Discussion

Paula's avatar
Paula
Icon for Helper I rankHelper 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
Icon for Microsoft Employee rankMicrosoft 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
    Icon for Helper I rankHelper 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.