Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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.
Proud to be a Super User!
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsYou 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.
Proud to be a Super User!
User | Count |
---|---|
120 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
166 | |
82 | |
68 | |
65 | |
53 |