SUM of columns in two different tables

[smatesic]

I've been encountering this issue more and more lately and can't find the solution. Is it possible to summurize two columns from two different tables?

Let's say I have this: Two tables in PBI. One is called "Salary", the other "Income". Each table has several columns including "amount of salary" (in Salary table) and "amount of income" (in Income table). Both columns are number type columns and I need to summarize them. Let's say total of "amount of salary" is 200.000 and total of "amount of income" is 500.000. I need to get that 700.000. How to do that if it's even posible?

[HarrisMalik · Accepted solution]

@smatesic It should be straight forward. Just create a new measure as

TotalAmount = SUM(Table1[Amount]) + SUM(Table2[Amount])

 It will give you sum on all conformed levels. If you need to do row by row sum then use SUMX function.

[Cherez]

Hi, Did you figure this out?

[Anonymous]

Hi, 

but this would give you the sum of the column. 

how would you get the sum of multiple measure by row like if it you wanted to sum the row values of a pivot table? 

Regards

[smatesic]

Thank you so much. It really is straightforward and so simple. Never crossed my mind to use + sign when there is sum function.Thank you again