More than just using USERELATIONSHIP(), it is complicated, need help

[catpoisoncat]

Hi experts,

I am experiencing something more than just using simple USERELATIONSHIP().

The situation is like this:

As you can see the relationship between 4 and 5 (yellow one) is inactive, but I need it to be active in order to use the yellow attribute in table 4 as a filter to apply to table 1 in my drill-through report. I've tried to change the direction from single to both, but it doesn't allow me. I've tried to use CALCULATE (EXPRESSION1, USERELATINOSHIP()), but I don't need to do any calculation in table 5, so I got stucked (BTW, it doesn't allowe me choose any attributes in table 5). I guess my ultimate goal is to make the red arrow pointed inactive relationship active. Can anyone help? Thanks.

[wdx223_Daniel]

please test these steps

1, delete the inactive relationship between 4 and 5

2,amend your measure by using TREATAS, for example, calculate(sum(table1[amount]),treatas(values(table4[key]),table5[key]))

[catpoisoncat]

Hi @wdx223_Daniel , thanks for your suggestion, I've tried it, it shows no error, but the result is not what I wanted, it is still showing the unfiltered outcome.