How to make an inactive relationship in powerbi active

[SGV]

Hi Guys,

Really need your help. I'm going crazy over here.

I need the relationship between active customers and campaign mapping to be active, but I'm getting the below error

The indirect relationship is coming from the raw customers and campaign mapping which I still need. I can't remove one for the other.
Kindly give me a workaround for this.

[Idrissshatila · Accepted solution]

Hello @SGV ,

you could use the userelationship measure to make it active for a specific calculation.

check it out https://youtu.be/z9_XSmlzemo?si=ClqKtAsGBVkq4hQ4

[SGV]

It works. Thanks alot.