How can I merge two matrix table with different measure value but same data for "Row"?

[Anonymous]

hello,

I have two matrix table.  They have the same data for the row but have different measures in the values. Is there a way to join these table on the Viz(report)?

Table 1		Table 2
	Actual	Budget			Variance
USA	100	50		USA	50
Germany	100	100		Germany	0
Canada	100	100		Canada	0

Final table
	Actual	Budget	Variance
USA	100	50	50
Germany	100	100	0
Canada	100	100	0

[Greg_Deckler]

Maybe, https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/td-p...

[parry2k]

@Anonymous best practice is to create a dimension table with countries and have a relationship with these two tables and then everything should be straight forward.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[amitchandak]

@Anonymous , Nor very clear. You can create a common country dimension and them against it

country = distinct(union(all(Table1[country]),all(Table1[country])))

Join with two tables

[Anonymous]

Unfortunately, the solutions do not work. How can I share/attach the sample Power BI dashboard on the forum?

[parry2k]

@Anonymous use onedrive /google drive to share.