Forum Discussion

juan_pablo's avatar
juan_pablo
Helper V
5 years ago

Why USERELATIONSHIP causes circular dependency?

Hi, Why a circular dependency is generated in such a simple model when I use the function USERELATIONSHIP? What's the logic of USERELATIONSHIP that causes it? I have the following model:   Table1...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

juan_pablo , Create first column like

Cantidad Asignada = SUMX(Filter(Table2 ,Table1[Item] = Table2[Item]), Table2[qtyAssigned])

juan_pablo's avatar
juan_pablo
Helper V
5 years ago

Thank you for your reply amitchandak . I know your formula works, but I want to know the explanation, the theory of why USERELATIONSHIP generates that circular dependeny.

Thanks.