How to properly create more than 1 relationship between two tables?

[mmelillo]

Hey, I'm new to Power BI and I can't create all the relationships that I need to make my visuals show the correct informations.
First table shows each Lead that a Sale Representative got. Second Table shows the sales that were made. Here are an example of the two tables that I have and the columns that they have in common:

Table 1 - Leads Distribution

Table 2 - Sales

Obs: Origin of Sale and Origin of Lead are equals. Each Sale Representative has only one Regional.

I need to create these 4 column relationships between the 2 tables. I'm able to create a relationship "many to many" between the Date columns but and when I try to create a relationship between any other column I get the error that are "ambiguous paths".

How can I properly create all this relationships? (Date-Date / Regional-Regional / Sale R.-Sale R. / Origin-Origin)

[sergej_og · Accepted solution]

Hey @mmelillo ,
maybe you have to create a key (calculated column) to achieve your result.
Concat your values in a suitable way and try again.
In best case your dim table has 1 and fact table n (1:n) relation.

Regards