Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Date Table relationship with multiple tables

I have several data sources in my file and I need to tie them all together so I can filter them all down to the same time-frame.  To do this, I created a date table and then I thought I would be able...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

That error means that you have multiple relationship paths between 2 tables and that creates confusion for the model. You can use USERELATIONSHIP in DAX to use a specific, inactive relationship. Would need to see your model to see what other fixes there may be. Often you can resolve these sorts of things by changing the filter direction on one or more relationships.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks.  Unfortunately, I am connected to a Postgresql DB and the model is far too complex for me to try to replicate it with Excel data and share.  I'll have to try to figure it out.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous,

     

    As the error prompted, it is not possible to establish two active relationships between two tables, that would bring confusion for the model. Please use USERELATIONSHIP in DAX to specify an inactive relationship.

     

    By the way, have you figured it out? If so, would you please share your solution so that it can benefit more users?

     

    Regards,

    Yuliana Gu