Can't Create Relationships due to 'Ambiguity'

[SamLund]

I'm creating a delay report, where individual delays are divided by Unit, then sub-divided by Major Component, then sub-sub-divided by Minor Component. Lists of Units, Major Components and Minor Components are all stored in their own tables, which are linked to the Delay table as shown below.

As you can see the links between the Unit-Major Component-Minor Component aren't active. If I try to activate them, I get the following error message:

Can anyone explain why this is happening? I don't see where the ambiguity between these tables and the Delays table comes from. Each Unit has a unique ID to match 1:Many to the Delays table, what is the ambiguity? 

[v-diye-msft]

Hi @SamLund 

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution. if not, please share more details about your question, we'd like to provide further support. thanks!

If you've fixed by your own, it would be much appreciated if you can share your solution here. 

[ibarrau · Accepted solution]

Hi. Let me explain.

The first thing you need to understand is that the relations in Relationships View will show you how the filters are going throw tables, directions.

The second is that power bi won't allow a table to recieve the same filter from two tables starting from one table. If you want to filter something from vwUnits to Delay, then you should pick only ONE route:

1- Directly to Delays

2- Go first to filter to vwMajorComponents and then filter Delays

This looks like a star schema, where Delays are facts and the other table dimensions. In my opinion you shouldn't activate filter between dimensions. Keep the model like it is right now (with that relationships inactive) and check this post if you want vwUnits filtering the vwMajorComponents that has a Delay.

https://blog.ladataweb.com.ar/post/185907335292/datamodeling-sincronizar-filtros-entre

Hope this helps.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]