DAX to show top 10 cities for total sales

%3CLINGO-SUB%20id%3D%22lingo-sub-1511281%22%20slang%3D%22en-US%22%3EDAX%20to%20show%20top%2010%20cities%20for%20total%20sales%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1511281%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20Fact%20sales%20and%20a%20customer%20table.%20I'd%20like%20to%20do%20a%20visualization%20of%20total%20sales%20for%20each%20of%20the%20top%2010%20cities%20and%20put%20all%20other%20smaller%20cities%20into%20something%20like%20%22others%22.%20How%20can%20this%20be%20done%20using%20DAX%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1511281%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDAX%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Pivot%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1513783%22%20slang%3D%22en-US%22%3ERe%3A%20DAX%20to%20show%20top%2010%20cities%20for%20total%20sales%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1513783%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70866%22%20target%3D%22_blank%22%3E%40Nima%20Mohandesan%3C%2FA%3E%26nbsp%3Bwhilst%20there%20may%20be%20people%20in%20this%20community%20who%20can%20answer%20this%20question%2C%20you%20are%20more%20likely%20to%20find%20PowerPivot%20and%20DAX%20experts%20in%20the%20Excel%20community%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fct-p%2FExcel_Cat%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fct-p%2FExcel_Cat%3C%2FA%3E%20than%20in%20the%20learning%20and%20certification%20community.%26nbsp%3B%20Sorry%20I%20cant%20answer%20your%20question%2C%20but%20hopefully%20signposting%20you%20to%20the%20correct%20place%20will%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20also%20the%20welcome%20post%20for%20this%20community%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fmicrosoft-learn%2Fwelcome-to-the-microsoft-learn-community%2Fm-p%2F1441597%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fmicrosoft-learn%2Fwelcome-to-the-microsoft-learn-community%2Fm-p%2F1441597%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1527861%22%20slang%3D%22en-US%22%3ERe%3A%20DAX%20to%20show%20top%2010%20cities%20for%20total%20sales%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1527861%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2292%22%20target%3D%22_blank%22%3E%40Sara%20Fennah%3C%2FA%3E%2C%20I%20should%20have%20paid%20attention.%20%3A)%3C%2Fimg%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

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? 

2 Replies

@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/...

Thank you @Sara Fennah, I should have paid attention. :)