use relationship More than once

[AhmedMousa]

hello 

i want use this function more than once can 

Tdr_net11 = calculate (

sum (Append_CR_gndtndr[TDR_AMOUNT]) / VALUE(1.15),

USERELATIONSHIP(Append_CR_gndtndr[TDR_DOB], Append1[INVD_DOB] ),

USERELATIONSHIP(Append_CR_gndtndr[TDR_STR_ID] ,Stores[STR_NO]))

[v-xulin-mstf]

Hi @AhmedMousa,

You can set these two relationships to be active in the Model view.
Then you can call the relationship multiple times and do not need to use the userrelationship function.

For more information, you can refer:

https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive#active-relationship...

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[lbendlin]

yes, that should be possible (assuming these relationships exist and they have the right filter direction).  Do you get an error?