https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Top-80-customer-gross-margin-and-other-customer-totals-20/m-p/773458#M3797 You can create a disconnected dimension, say Grouping, that will hold two values: "Top 80% Totals" and "Other Customers." Then, in the dimension, create the measures you want - [Total Sales - Grouping], [Total Cost - Grouping], [Gross Profit - Grouping] and [% of Total - Grouping].<BR /><BR />Best<BR />Darek Thu, 22 Aug 2019 18:05:15 GMT Anonymous 2019-08-22T18:05:15Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Top-80-customer-gross-margin-and-other-customer-totals-20/m-p/772065#M3741 <P>I am attempting to recreate an original report in powerbi. I have recreated all columns but I am having issues creating the totals rows - showing Top 80% totals and Other Customers, and Grand Total. I tried index but that does not seem to be working, also I am not seeing top N in filter options. Anyone know what is the best way to accomplish this?&nbsp;</P><P>&nbsp;</P><P><img /><img /><img /></P> Wed, 21 Aug 2019 15:22:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Top-80-customer-gross-margin-and-other-customer-totals-20/m-p/772065#M3741 granade1 2019-08-21T15:22:41Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Top-80-customer-gross-margin-and-other-customer-totals-20/m-p/773458#M3797 You can create a disconnected dimension, say Grouping, that will hold two values: "Top 80% Totals" and "Other Customers." Then, in the dimension, create the measures you want - [Total Sales - Grouping], [Total Cost - Grouping], [Gross Profit - Grouping] and [% of Total - Grouping].<BR /><BR />Best<BR />Darek Thu, 22 Aug 2019 18:05:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Top-80-customer-gross-margin-and-other-customer-totals-20/m-p/773458#M3797 Anonymous 2019-08-22T18:05:15Z