Forum Discussion
Solved
Accumulating subtotals
Is it possible to add accumulating sub totals into a matrix table in Power BI. So for example Income, cost of sales and then a subtotal called gross profit, then overheads and another subtotal called...
Hi guyclewlowi2,
>>So for example Income, cost of sales and then a subtotal called gross profit, then overheads and another subtotal called net profit. The net profit would be a calculation of gross profit + overheads and not just total the overheads
Power bi not support these feature, you should write measures to calculate for these calculations and drag them to values field.
Regards,
Xiaoxin Sheng
Ashish_Mathur
Super User
Super UserHi,
This can be done in Excel using CUBE functions.
These each would be written as separate measures(i.e. [Income], [Cost of Sales], and [Gross Profit]), then in your matrix you would use the new "show measures on rows" formatting feature to get the layout you're describing.