Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

RANKX Issue

 

I want to show the rank based on the customer name only.

Here is the formula used

Customer Rank  = RANKX( ALL( Sales[CustomerName]), [Amount],,DESC)
Please help .
Need Help

4 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    6 years ago

    Hello Anonymous 

    Give this a try.

    Customer Rank =
CALCULATE (
    RANKX ( ALL ( Sales[CustomerName] ), [Amount],, DESC ),
    ALLSELECTED ( Sales[StateName] )
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      It worked . Still there is an issue brother. Same customer with different state is showing in different rows.

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Would you like to provide some sample data?I need to understand a clearer model.

     

    Best Regards,

    Eads

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Please refer image, data is from a single table only.