Creating a Bridge table with multiple columns

[akhaliq7]

I am importing two seperate tables into Power Bi which return a m:m relationship. To tackle this I created a bridge table but in Power Query editor, Using the following tutorial: How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive 

The problem I am getting is having done the above tutorial I managed to have 1 column work which is the order id column. But when I try to filter both tables using sales persons I am not getting the results in both tables with 1 table showing empty rows.

I thought of creating another bridge table for sales persons name or id but then there is ambiguity in the relationships. 

What can I do to solve this, Create a bridge table with order id, sales person id and sales persons name?

The problem with the above solution is I don't know how to remove nulls from just one column as query editor tries to remove only nulls where all 3 columns contain nulls

Currently my bridge table only contains order_id. 

[amitchandak · Accepted solution]

@akhaliq7 , Try a table like this DAX. Based on what I got

filter( distinct(union(distinct(Table1[sales person id]),distinct(Table1[sales person id]) )) , not(isblank([sales person id])) )