DAX to show top 10 cities for total sales

[Nima Mohandesan]

Hi,

I have a Fact sales and a customer table. I'd like to do a visualization of total sales for each of the top 10 cities and put all other smaller cities into something like "others". How can this be done using DAX? 

Thanks, 

N

[#2 · Accepted solution]

@Nima Mohandesan 

The pattern is here https://www.sqlbi.com/articles/showing-the-top-5-products-and-others-row/