A circular dependency was detected

Hi  Anonymous  ,

I created the data myself, simulated it again, and it can be displayed:

Column =
CALCULATE(SUM('Table'[amount]),FILTER('Table','Table'[Month]=EARLIER('Table'[Month])))

My guess is that the formula in your calculated column[Fault_code] caused the circular dependency.

can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Reasons for circular dependence:

In some scenarios, the DAX engine cannot build the dependency diagram. If two objects depend on each other, the engine does not know which one to compute first. If A depends on B and – at the same time – B depends on A, then it is impossible to compute A nor B. As soon as you compute A, this triggers the refresh of B. So you start refreshing B, wich in turn triggers the refresh of A. You are stuck in an infinite loop with no hope of ever getting the job done.

This is a link about circular dependencies, I hope it will help you:

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

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.