circular dependency error

[kevinconseil]

I am confronted with a circular dependency error - even though there is no dependency that i can identify, can someone help?

I want to calculate this column, that shows if in one order all the lineitems were shipped completely:

Order Is Incomplete  = if(MINX(FILTER(table, table[Order No] = Earlier(ErpPostedSalesShipmentLines[Order No])), table[In-Full - Item]) = 0, "Yes", "No")

"In-Full - Item" is another calculated column that shows if each lineitem in an order was shipped in full (there can be multiple entries per item for an order --> In-Full - Item = if([quantity_sum]-[originally_ordered_quantity_sumx] >= 0, 1, 0).

"In-Full - Item" refers to the measures (in the column originally ordered entires for the lineitem can be doublivated and should only be counted once per lineite*order)

• quantity_sum = sum(table[Quantity])
• originally_ordered_quantity_sumx = SUMX (VALUES (table[No]), CALCULATE (Min(table[OrginallyOrderedQuantity])))

I cannot detect a circular dependency in this and do not know how to solve this. Appreciate any help on this!!

[DOLEARY85]

Hi,

This post should help understand why it's happening and how to resolve it: https://community.fabric.microsoft.com/t5/Community-Blog/Circular-Dependency-between-Calculated-Colu...

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍