Jul 09 2020 02:45 AM
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?
Jul 10 2020 12:35 AM
@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/...
Jul 16 2020 03:01 PM
Thank you @Sara Fennah, I should have paid attention. :)