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

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

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

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
    Icon for Super User rankSuper 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