Forum Discussion
circular dependency error
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!!
1 Reply
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-Columns-in-a-Table-in-DAX/ba-p/1877267
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
