How to show the data in a many to many with bridge table

[Anonymous]

I have two tables A and B. These table need to be joined based on ordernumber but it is throwing me many to many problem.

I then created a bridge table with unique ordernumber. Now related them as below

A(ordernumber) -> Bridge(ordernumber) <-> B(ordernumber)

When I try to pull the fields from A, B tables onto a chart, I still get an error 'relationship cannot be determined'. Can someone help here why the bridge table is not letting to filter A and B tables. How can I resolve this pls?

[Phil_Seamark]

Hi @Anonymous

It looks like it should work.  I've built a simplified example using just three tables and you should be able to see it working here

https://1drv.ms/u/s!AtDlC2rep7a-ox4finTCl6MiI5dS

[Anonymous]

@Phil_Seamark Thanks for the input. I see that working in your example. but its not working in my case. I am creating the bridge table from one of the two table by removing duplicates and other columns (just keeping ordernumber). Is that any reason that I still get relationship not detetcted error. 

[impresent]

You need to drag a measure in order to remove the error. if you select a measure also then you will be able to get the columns from both the table connected through bridge table.

[v-xjiin-msft]

Hi @Anonymous,

Could you please share us your pbix file with One Drive or Google Drive if possible? So that we can dig deeper and provide some proper suggestion.

Thanks,
Xi Jin.