Circular dependencies

[o59393]

Hi all

I need to multiply a demand measure from my table called ''Query1'' with a column of another table called ''Demand Incremental'' that contains incremental percentages. Between the 2 previous tables there is another ones called ''SKU by line'' that connects the them.

For the multiplication to be calculated correctly, the direction between ''demand incremental'' table and ''SKU by line'' table should be both and not single as it is currently.

If I try to change it to both I get the message below:

After doing some tests, I realized that the problem is caused by a lookupvalue function between Demand Incremental table and SKU by line table:

So if I get rid of that function:

The both direction will now work:

Is there any idea how to fix this?

Thanks.