RANKX Issue

Anonymous · ‎08-24-2019

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 .

v-eachen-msft · ‎08-26-2019

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.

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

Anonymous · ‎08-26-2019

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

jdbuchanan71 · ‎08-24-2019

Hello @Anonymous

Give this a try.

Customer Rank =
CALCULATE (
    RANKX ( ALL ( Sales[CustomerName] ), [Amount],, DESC ),
    ALLSELECTED ( Sales[StateName] )
)

Anonymous · ‎08-26-2019

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

Helpful resources