Ambiguity relationship issue - help needed

[yanivshe]

Hi,

I have a lab fixes data. Each customer order comes to lab for a check and fix if needed.

The open date is the date the customer opens a ticket.

The received date is when we receive the unit in our lab.

The closed date is when the ticket is closed by us.

I want to make a BI relationship so the managers will be able to view amount of units by open\received\closed dates and view status of units in lab by date.

Here is the data relationship I did:model relationship diagram

model relationship config window

relationship property window

The 2 dot relationships are not active.

Whe I try ti activate them I get an error:

"You cant create a direct relationship between Closed_Dates and Main that would introduce abiguility between table Date and Closed_Dates. To make this relationship active, deactivate or delete one of the relationships between Date and Clsoed_Dates first."

I read that Power BI relationship directions matter, I tried to do many:many with a direction but with no luck.

Any help with this on plea

[az38]

Hi @yanivshe 

You are already have relations between Main and Data tables via Open_Dates, so it's incorrect to try create any other ways

Maybe you should try to create the onlye table with Datas (your 3 tables have similar structure now)

Use columns :

ID

DataType (Open/Receive/Close)

Date

Datetime

And further just use filters by DataType

It should be enough for a lot of scenarios