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
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.