Sum together grand totals from different matrix tables

[Anonymous]

Hi,

I am trying to find a way to add the totals together of two matrix tables on separate sheets in Power Bi. Both come from the same imported data.

I am trying to make a P&L statement which goes from Sales, to GP, to Operating expense then to Net Income and EBITDA.

I have one sheet which shows the whole walk down to Net Income as a matrix table.

But what I need to do now is add back Depreciation.

On a separate sheet I have an exhibit for depreciation as a matrix table.

How can I add them together? We had a vendor demo in and I know they did it, but I am not sure how.

[v-yulgu-msft]

Hi @Anonymous,

I am not very clear about what you were trying to achieve. Please follow this blog to provide more details.

Regards,

Yuliana Gu

[Anonymous]

What is unclear?

I have 2 sheets within a Power BI report. Both are matrix data tables with the same underlying database cube.

I need to take the grand total of one and add it to the grand total of the other.

[v-yulgu-msft]

Hi @Anonymous,

Currently, it is not supported to make calculation on row level in a Matrix. I'm afraid the requirement that to sum up grandtotals and display the results on new rows cannot be achieved.

Regards,

Yuliana Gu

[bizbi]

Hello,

You can try joining the two tables using a concatenated column of all slicer columns on the desired page of the report.

Can you give some sample data and the expected result for better explaination?

[Anonymous]

I do not really follow what you describe. I do not think adding columns will work because I know I need to add rows.

 Here is an example of the output.

Item	Value	How calculated?
Revenue	90,000
Cogs	1,000
GP	89,000	Rev - Cogs
Depreciation	9,000
All other Opex	30,129
Total Opex	39,129	Dep+all other
Net Income	49,871	GP- Total Opex
Depreciation	9,000	I need a way to add this back to net income
EBITDA	58,871	Total of Net Income + Depreciation

So everything comes from the same data source, but I have one sheet that calculates down to Net Income and another that calculates the 9,000 in depreciation. What I need to do is somehow in one dashboard Add back the depreciation. All data is from the same source

[Anonymous]

Any thoughts?