Top 80% customer gross margin - and other customer totals (20%)

[granade1]

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? 

PowerBIColumns-Original RptTotals-Original Rpt

[Anonymous · Accepted solution]

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].

Best
Darek