Forum Discussion
Measure values problem from another table in table view in Power BI desktop
Hello,
First 3 columns are from table 1 and last column is from table 2. I need breakup of measure test like the same in image 2. Country_test in image 1 is a column from table 1 and country_desc is a column from table 2.
As of now, it is coming the grand total in all the rows.
Please help.
Image 1
Image 2
Anonymous , This means one of the tables has unique countries
Try new table like
country = distinct(union(distinct(Table1[country]),distinct(Table2[country])))
now join with both country
6 Replies
- amitchandak
Super User
Anonymous , seem like table 1 and table 2 do not have to join.
I think you need to have a common country table and join both tables with that and then analyze them together.
how to create such a common table
https://www.youtube.com/watch?v=Bkf35Roman8
- amitchandak
Anonymous , This means one of the tables has unique countries
Try new table like
country = distinct(union(distinct(Table1[country]),distinct(Table2[country])))
now join with both country
- Jihwan_Kim
Hi, Anonymous
I am not sure how your data model looks like, but it seems like those two tables are not connected.
Please try to make the relationship between the two tables.
Or, please share your sample pbix file's link here.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
- Jihwan_Kim
Hi, Anonymous
Thank you for your feedback.
I am not sure how your data model looks like. Please try to use TREATAS function inside your measure.
Or, if it is ok with you, please share your sample pbix file's link here.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
