The relationship between the tables isn't working

[singh_gagan03]

Hi All,

I have 2 tables joined with a bridge table in the data model using the material_code using one to many relationship.

I am making a tabular visual and used a measure in it but apparantely the Material from table 1 and Material from Table 2 kinds of mismatched, I have the result below.

[amitchandak]

@singh_gagan03 , the screenshot you shared not making it clear what is the mismatch. What is the join columns ?

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[singh_gagan03]

@amitchandak Hey how do i share a file with you or can we take this offline on a zoom call?

[v-deddai1-msft]

Hi @singh_gagan03 ,

You can share the sample pbix by onedrive for business and your expected output. And  please try to change the two relationships to bi-directional.

This mismatch is likely due to the fact that the Table1‘s filter failed to pass to Table2. 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Sumanth_23]

hi @singh_gagan03 - the question is not too clear - will you be able to post a sample dataset. Also can you please share the expected outcome to better understand what you are trying to achieve. 

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!