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