Power BI "An Active relationship already exists between tables" Deactivate the existing relationship

[ksbiexpert06]

Hi , I have a complex data model and some of the tables has multiple joins between two tables and i am not able to define multiple joins between the two tables. I am getting an error "Power BI "An Active relationship already exists between tables" Deactivate the existing relationship first".. Below is a quick example and not the actual tables. Its allowing me only to activate only one relation ship ..? Any suggestion

[MFelix]

Hi @ksbiexpert06,

In PBI you can only have one active relationship between tables, although you can have more than one relation between tables only one will be active.

The option here is to create dimension tables with unique values and pass the relationships for both tables trough those dimension tables creating a star schema.

Regards,
Mfelix

[KHorseman · Accepted solution]

You can only have one active relationship between two tables. You can however create as many inactive relationships as possible. It's easiest to do this through the Manage Relationships button on the Modeling tab in the ribbon. Once you've added them, you can write measures to reactivate them for specific calculations with the USERELATIONSHIP function. In cases where you need more than one relationship between the same two tables, I recommend making none of them active, simply toggle them back on with USERELATIONSHIP.