Relationship Ambiguity

[Anonymous]

Hello Everyone,

I will try my best to explain my current problem with relationship ambiguity, i will start first with what im looking for

My task is to be able to create two slicers that can filter data coming from three different data sets. The two slicers are called "Cost Phase" and " Well ID"

I realized that i was able to link the "Cost Phases" in the three datasets named "CJI3 Data" & "OW Data" & "Split Cost". However, once i do the same with my two DIM_ well short and DIM_well long i get the ambiguity error

The 2 DIM tables basically include the same Well ID in all 3 main datasets and the reason why i have well name 1 & 2 is because "well name 1" has a short well name similar to the one in "CJI3 data" & "Split Cost while "well name 2" has a long well name similar to "OW data"--> thats why i created two DIM tables

Below is a screenshot for my current active relationships..appreciate if someone can help fix the problem 

[MFelix · Accepted solution]

Hi @Anonymous ,

In the screenshot you have relationship from many to many, that will bring the issues you are refering.

You need to create dimension tables with unique values to link the 3 tables on a one to many relationship.

Is the HPM Phase (CJI3 table ) the link to the Cost Phase (OW Data) if yes the dimension table needs to be the Cost Phase column.

Regards,

MFelix

[Anonymous]

Thanks @MFelix  it worked perfectly for both my filters ( Well ID & Cost Phase)