Measure values problem from another table in table view in Power BI desktop

[amty63]

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

[Jihwan_Kim]

Hi, @amty63 

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

[amty63]

There is circular dependency is detected while joining to the country table.. that is the reason I don't join with the table... can't we do without joining the tables ... some DAX formulas

[Jihwan_Kim]

Hi, @amty63 

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

[amitchandak]

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

[amty63]

There is circular dependency is detected while joining to the country table.. that is the reason I don't join with the table... can't we do without joining the tables ... some DAX formulas

[amitchandak · Accepted solution]

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