Active / Inactive relationships

[Mike_Mace]

I use "Date" and "Company" in standalone tables in order to create relationships with variables (planned and actual). On one report the relationships work fine for both Date and Company.

On a second report where I use the same process the relationship does not become active on Company. I get an attention message "You can't create a direct active relationship between Company and MEP Actual because that would introduce ambiguity between tables Date Calendar and MEP Planned. To make this relationship active, deactivate or delete one of the relatioshops between Date Calendar and MEP Planned first."

Why isn't that message shown on the first report?

Am I missunderstunding something with relationships?

Notworking relationships

@v-lid-msft,  https://community.powerbi.com/t5/Desktop/Filtering-multiple-curves/td-p/1038960

[Greg_Deckler]

It's not the same, in your first model, Date Calendar table has 2 paths to MEP Actual table. Just follow your arrows.

You cannot have 2 active pathways between the same 2 tables in your model. If you create 2 paths, one will become inactive. You can still use it by specifying USERELATIONSHIP. However, if you find yourself using USERELATIONSHIP nine times out of ten, you should rethink your data model. 

[Mike_Mace]

Hi @Greg_Deckler ,

The second arrow led to another independent variable. It's not affecting MEP Actual table. 

Reattaching with the relationships to the other viariables deleted.

[Greg_Deckler · Accepted solution]

OK, look at your picture and follow your arrows

Path 1: Date Calendar -> MEP Planned -> Company -> MEP Actual

Path 2: Date Calendar -> MEP Actual

2 paths, both cannot be active. I don't know how to explain this any differently. 

For that matter, you also have 2 paths from Date Calendar to Company and Date Calendar to MEP Planned so you basically just have a big circle and that is generally not a good data model.