cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

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

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
 ActualBudget  Variance
USA10050 USA50
Germany100100 Germany0
Canada100100 Canada0

 

Final table
 ActualBudgetVariance
USA1005050
Germany1001000
Canada1001000
5 REPLIES 5
Highlighted
Super User IV
Super User IV

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

@ShriHanuman , 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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Super User IV
Super User IV

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

@ShriHanuman 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!






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Super User IV
Super User IV

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

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

---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Helper II
Helper II

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

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

Highlighted
Super User IV
Super User IV

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

@ShriHanuman use onedrive /google drive to share.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors