Bridge table problem

[mgils24]

Hi all,

I'm struggling with a bridge table in a larger data set. In order to understand the bridge behavior I created a simple dataset. The result is not how I expected. I have 2 tables: 1 with names and work location and the second with names and home location. I use a bridge table to connect the names. See:

The problem occurs when I want to make a combined list:

I want to get this:

[powerbidev123]

Hi @mgils24 , I have used the same dataset but getting the desired result as mentioned by you.

The only difference I see is that the relationship you have is 1 to many and bidirectional cross filter whereas in mine its coming out as 1 to 1 with bidirectional cross filter

[mgils24]

Hi @powerbidev123 ,

Sorry for not being complete. I can't change to a 1-to-1 relationship. In my Tables I deliberately duplicated some rows as my original data also contains this. Removing the duplicates indeed gives the wanted result.