using inactive relationship

Hi Zyg_D ,

In your data, the ColorID of Cat is 2 and that of Plant is 3. But in table PetToy, when Pet = Cat, Toy = Plant. In the existing relationships, the ColorID will get value like this:

'Toy'[Toy] -> 'PetToy'[Toy] -> 'PetToy'[Pet] -> 'Pet'[Pet] -> 'Pet'[ColorID] -> 'Color'[ColorID].

So, it will return White for Plant.

It is suggested to make the relationship between 'Pet' and 'Color' inactive, too.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

This works without changing any relationship: 

ToyColor = 
CALCULATE (
    MINX (
        Toy,
        RELATED ( Color[Color] )
    ),
    USERELATIONSHIP ( Toy[ColorID], Color[ColorID] ),
    ALLEXCEPT ( Toy, Toy[Toy] )
)