Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 i...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
Jihwan_Kim
Super User
5 years ago

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