Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
2 years ago

Ciruclar Dependency Error - HELP!

Hi all

 

I am getting a circular dependency error, which I have no clue how to fix because no major detail is given:

 

A circular dependency was detected: SKU by line - Official[Column].

 

Capacity Bottler Hours (Mix Hours) = 

Var mix = 

CALCULATE('SKU by line - Official'[Mix by Line Bottler (Hours)],
REMOVEFILTERS('SKU by line - Official'[Capacity Bottler (Mix UC)])
)

Var result = 

         mix 
            * RELATED( 
                'Hours by line - Official'[Available Production Hours]
            )

return result

 

 

Any idea how to fix this?

 

Thanks.

 

Circular dep test.pbix

 

Test_PBI_CircularDep.xlsx

 

 

Need Help
Show and Tell

2 Replies

  • Zang_Mi's avatar
    Zang_Mi
    Icon for Resolver II rankResolver II
    2 years ago

    Hello, can you please give more detail about the measure and columns/calculated column used in that formula? It is likely that they depends on the same data field.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank @Ahmedx  for your prompt reply.

    Hi o59393 ,

    Based on the details you provided, the calculation you are attempting appears to create a loop between the metric and the column. A circular dependency typically occurs when two or more items in a data model depend directly or indirectly on each other, thus creating a loop. To resolve this issue, you can take the following steps:

    1. Ensure that the relationships between tables are set up correctly. Sometimes circular dependencies can be solved by reorienting relationships or removing unnecessary relationships.
    2. Try to simplify the calculation. Break down the calculation into smaller, more manageable parts and verify at each step that no loops have been inadvertently created.
    3. When you are already using variables, make sure they do not create loops. Sometimes, adjusting how variables are used in DAX formulas can help eliminate circular dependencies.
    4. Ciruclar Dependencies are not always straightforward. Indirect circular references may occur if another metric or calculated column you are using in a calculation depends on the code you have given. Check all related measures and calculation columns for potential indirect circular references.

    Best Regards,

    Ada Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.