Show TopN Provinces and Others in Microsoft #PowerBI Province_ = VAR Rank_ = RANKX ( ALL ( Province ), [Total Orders $],, DESC ) RETURN IF ( Rank_

Dynamic TopN Others in Microsoft #PowerBI #DAX NetOrders TopN Others = VAR RankProductsbyNetOrders = RANKX(ALl(Products), [Net Orders $],,DESC) return IF(RankProductsbyNetOrders<=9, Products[Product Name], "Others") EXPLANATION: 1 - Ranking Products by Net Orders: RANKX(ALL(Products), [Net Orders $], DESC): This part ranks all the products in the 'Products' table based on their 'Net Orders $' in descending order (DESC). So, the product with the highest net orders gets rank 1, the second highest

RANK & RANKX DAX Example in Microsoft POWER BI | #DAX #POWERBI Rounded Sales = MROUND([Total Orders $], 100000) Rank = RANK(ALLSELECTED(Customers[Province]),ORDERBY([Rounded Sales], DESC, Customers[Province], DESC)) RANKX = RANKX(ALLSELECTED(Customers[Province]),[Rounded Sales],, DESC, Dense) | Excel Basement