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.

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

ValtteriN  my measure return wrong value . In both table common value  ChildTMC ,Affiliate.
for example 

Affiliate                  ChildTMC        

1002020                LOOF                   

 

FixedShipments  value  zero  but i have applied measure its return value 17.50 

Anonymous's avatar
Anonymous
Not applicable
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.