Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I want to show the rank based on the customer name only.
Here is the formula used
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.
Please refer image, data is from a single table only.
Hello @Anonymous
Give this a try.
Customer Rank = CALCULATE ( RANKX ( ALL ( Sales[CustomerName] ), [Amount],, DESC ), ALLSELECTED ( Sales[StateName] ) )
It worked . Still there is an issue brother. Same customer with different state is showing in different rows.