How to total amounts from 4 different, unrelated tables?

[Nicci]

Hi hivemind!

I need to create a tile with 'starting balance' in it which is the total amount recorded in 4 different database tables. The tables are completely unrelated to each other, they are 4 different source accounts. How would I create a view/tile/something to take the 'total' column of each 4 table and add them together to get the single full amount? Thanks!

[johnt75 · Accepted solution]

Create a measure like

Grand Total = 
SUM( 'Table 1'[Column]) + SUM( 'Table 2'[Column]) + SUM('Table 3'[Column]) + SUM( 'Table 4'[Column])

[Nicci]

Thank you!!!! I didnt realize I can simply just grab different tables like this I thought it had to all be in one table first!