Forum Discussion
Creating Relationship Issue (ambiguity)
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?
Create separate table for Campaign then join both tables with this Campaign table.
4 Replies
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
Create separate table for Campaign then join both tables with this Campaign table.
Thanks, that helped. (Y)
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
