Forum Discussion

yanivshe's avatar
yanivshe
Helper I
6 years ago

Ambiguity relationship issue - help needed

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

 

1 Reply

  • az38's avatar
    az38
    Community Champion

    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