Total Sum Over Multiple columns in different tables

[Anonymous]

Hello, I am trying to create a measure where I can get the total sum of price grouped by 3 columns. Each column is in a seperate related table.

Here is a rough idea of what im trying to do,

SUM( SUM of Price grouped by Column 1,  SUM of Price Grouped by column 2, SUM of Price Grouped by column 3 )

How can I implement this? Thank you

[v-robertq-msft · Accepted solution]

Hi, 

According to your description, I can roughly understand your requirement, I think you can use the ALL() function to get the total to avoid the table relationships, you can try this measure:

This is the test data I created based on your description:

Total Sum =
var _sum1=SUMX(ALL('Table'),'Table'[Price1]) 
var _sum2=SUMX(ALL('Table (2)'),'Table (2)'[Price2]) 
var _sum3=SUMX(ALL('Table (3)'),'Table (3)'[Price3]) 
return _sum1+_sum2+_sum3

And you can create a card chart to place the measure to get what you want, like this:

You can download my test pbix file below

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Output is not clear.

A table like

Union (
summarize(Table, Table[Col1] , "_Mes", [Measure]) ,
summarize(Table, Table[Col2] , "_Mes", [Measure]) ,
summarize(Table, Table[Col2] , "_Mes", [Measure]) )

and measure like 
Sumx( Union (
summarize(Table, Table[Col1] , "_Mes", [Measure]) ,
summarize(Table, Table[Col2] , "_Mes", [Measure]) ,
summarize(Table, Table[Col2] , "_Mes", [Measure]) ) , [_mes])