Forum Discussion
DAX join two summarize outputs
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.
5 Replies
- amitchandak
Super User
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.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.
