DAX join two summarize outputs

[Anonymous]

Hi,

I have one measure 'Actual Volume' from table1, I can to break it down with 2 different columns from table 2 and table 3:

And I would like to have both in one visual summed like below:

is there a way I can do that?

Thanks.

[amitchandak]

@Anonymous , You have created a common table country and then you can create a measure like

sum(Table1[value]) + sum(Table2[value]) 

refer for common table : https://www.youtube.com/watch?v=Bkf35Roman8

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

[Anonymous]

@amitchandak , sorry I should have been more clear, the screenshots are just matrix visual. The measure is one table, the 'County' columns are in 2 other different tables. it is the same measure that is breakdown by 2 different columns from 2 different tables.

[amitchandak]

@Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

@amitchandak , I am using tabular model so I  can't provide the pbix, below is the part of the model I need for this request:

below is the sample data:

I need the output as below:

[v-easonf-msft]

Hi, @Anonymous 

If  your table2 and  table3 are similar in structure,you can take a  try to   append this two Queries  as  a new query in Query Editor .

In this way you can  get the  partial results of table columns as follows.

You can also try to create a  similar calculated table using "summarize"  and "union"  functions

If it doesn't work ,please share sample pbix file for testing.

Best Regards,
Community Support Team _ Eason