Many relationship on dimensionto be activate

[Anonymous]

Hi,

I have an issue.

I have a fact table which contains two persons: The holder of a contract and eventually his/her partner.

They are both linked to a person table dimension...

When I link both to my dimension table with power pivot I can't activate both relationship:

How can I manage that? Do I need to make two versions of the dimension table?

Thanks for answers.

[amitchandak]

@Anonymous , seem like bi-directional relation or over-model creating loops of two paths and the relationship is inactive. check the model and try to resolve that

if you have a valid inactive then we can use userelationship

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi