Filtering multiple dimensions by a single "parent" dimension

[moorejr7]

Hello,

I'm trying to create a model where I have one parent dimension that is filtering down two other dimensions. The model is supposed to be following a snowflake schema. The two child dimensions then need to be connected to facts. However, I cannot create all of the relationships that I need to due to "ambiguity between tables". Here is the model I have created:

As you can see, the two relationships from Child Dimension 2 that are connecting to Fact 1 & 2 are inactive. This is where my problem is. When trying to activate either of those relationships, I receive the following error message:

Any help or tips at all would be greatly appreciated!

[v-chuncz-msft · Accepted solution]

@moorejr7 ,

You may take a look at USERELATIONSHIP Function. It allows you to specify the relationship to be used in a specific calculation.