Circular Dependency

[aishak12]

Does anyone know why this error is happening and how to work around it or resolve. 

Thanks

[v-yangliu-msft]

Hi  @aishak12  ,

Place a measure in the calculation column, and there is a high probability that Circular Dependency will appear. You can convert this calculation column into a measure.

For related documents, you can check the following link:

https://www.sqlbi.com/articles/understanding-circular-dependencies/

https://community.powerbi.com/t5/Desktop/quot-A-circular-Dependency-was-detected-quot-error-while/m-...

https://community.powerbi.com/t5/Desktop/A-circular-dependency-was-detected/m-p/433776

Best Regards,

Liu Yang

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

[Greg_Deckler]

@aishak12 Not with that amount of information. The error tells you the columns/measures causing the circular dependency. Avoiding circular dependency errors in DAX - SQLBI