Forum Discussion

catpoisoncat's avatar
catpoisoncat
Frequent Visitor
3 years ago

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

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.

USERELATIONSHIP

2 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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's avatar
      catpoisoncat
      Frequent Visitor
      3 years ago

      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.