Creating Relationship Issue (ambiguity)

[usmanrafiq]

Hello, 

I have three tables DimDate , Ads_Drivilogy2 and Ads_Driviology3

I want to create 3 relationships between these tables

1. Date of Dim Date with Date of Ads_Drivilogy2

2. 1. Date of Dim Date with Date of Ads_Drivilogy3

3 Campaign of Ads_Drivilogy2 with Campaign of Ads_Drivilogy3

The first two relationships are active but when I tried to active 3rd relatiobship it says 

How to resolve this issue?

[Tahreem24]

@usmanrafiq ,

Try to solve it by usinf Bridge table of Campaign. For more deets refer the below thread:

https://community.powerbi.com/t5/Desktop/Ambiguity-relationship/m-p/560891

[amitchandak]

@usmanrafiq , You need to have Campaign  as bridge table or common dimension .

refer

https://www.seerinteractive.com/blog/join-many-many-power-bi/

https://radacad.com/power-bi-basics-of-modeling-star-schema-and-how-to-build-it

Create a common/bridge table code -

https://www.dropbox.com/s/op9lb78w9utdonz/Distinct%20from%20two%20Tables.pbix?dl=0

[FarhanAhmed · Accepted solution]

Create separate table for Campaign then join both tables with this Campaign table.

[usmanrafiq]

Thanks, that helped. (Y)