How to show ratings given to top n customers based on their order amount

[Anonymous]

Hi All

I want to show the ratings (e.g. - Poor, Good, Excellent) given to my top n customers ( top n cutomers I am getting based on their order amount).
Is it possible to plot how many of my Top N customers have got either poor or good or excellent rating in pie chart

[PaulOlding]

Hi,

There's a few assumptions here because it's not clear what format your data is in.

I loaded this data:

We'll need 2 simple measures:

Customer Count = DISTINCTCOUNT('Table'[Customer])

Order Amt = SUM('Table'[Order Amount])

Set up a pie chart like so:

Then add a visual level filter to get the Top N

[Anonymous]

Thanks for your response, really appreciate but need to create measure to find the top n customers and their order amount that is already been done. Please refer to the solution for a similar situation(there top n locations have been retreived on sum of loss amount) given by @OwenAuger in Solved: Re: Top N Locations based on 2 measures - Microsoft Power BI Community, I need to get the ratings for Top N customers (based on their order amounts.