Create group "Other" based on sales per month

[JLiljedahl]

I have a one-pager showing all different kind of data as a monthly report.

To show the sales I use an Matrix listing all customers ranked by sales (from high to low). 

Currently, all customers is displayed and the matrix becomes very long (or not fully displayed if decreasing the window) 

I want to show 9 customers on the list (the 9 highest for the month) and the last "Customer" should be named "Other" were all others are group together.

The 9 customers could vary depending on the sales of individual month.

In the matrix I have today "Customers" as rows and "Total Sales" as values.

Any proposed solution?

[JLiljedahl]

Hey @rubayatyasmin 

Solution "TopN" works but how do I sort when using customer names instead of numbers as in the example?

I want to sort so that "Other" always is in the bottom even if the total value of "Other" is higher then last TopN value 

(e.g. Others sum up to 100k and customer 10 has 80k)

[rubayatyasmin]

Hey, @JLiljedahl 

Use TOPN dax func

refer: https://learn.microsoft.com/en-us/dax/topn-function-dax

I found a similar thread that might help: 

Solved: TopN and "Other" filtered by month - Microsoft Fabric Community

Solved: Creating a group of "others" by total sales - Microsoft Fabric Community