Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

can't create direct active relationship

 i am trying to create active relationship between two tables . i am getting error you can't create direct active relationship between  Out_Duration_ChildTMC_Affiliate_Final and  Out_RefernceDates be...
Help appreciated
Help me
Help Requested
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    USERRELATIONSHIP function works.

    My sample data is as follows.

     

    What you need to pay attention to is that your relationship is to be created an inactive relationship, uncheck this option.

     

    Measure = CALCULATE(SUM('Out_Duration_ChildTMC_Affiliate_Final'[FixedShipments]),USERELATIONSHIP(Out_Duration_ChildTMC_Affiliate_Final[Affiliate],Out_RefernceDates[Affiliate]))

     

     

    Best Regards,

    Stephen Tao

     

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