Forum Discussion
Nima Mohandesan
Jul 09, 2020Copper Contributor
DAX to show top 10 cities for total sales
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 th...
SaraFennah
Jul 10, 2020MVP
Nima Mohandesan whilst there may be people in this community who can answer this question, you are more likely to find PowerPivot and DAX experts in the Excel community here https://techcommunity.microsoft.com/t5/excel/ct-p/Excel_Cat than in the learning and certification community. Sorry I cant answer your question, but hopefully signposting you to the correct place will help.
See also the welcome post for this community https://techcommunity.microsoft.com/t5/microsoft-learn/welcome-to-the-microsoft-learn-community/m-p/1441597
Nima Mohandesan
Jul 16, 2020Copper Contributor
Thank you SaraFennah, I should have paid attention. 🙂