Circular dependency errors in DAX are perhaps the most feared of all DAX errors. In short, a circular dependency is essentially a loop where a value, A, depends on another value, B, which depends on the original value, A. The reason that circular dependencies tend to be feared is that people do not necessarily understand where circular dependencies come from, and so circular dependencies can be complex and time-consuming to troubleshoot and resolve, especially in complex data models and complex DAX calculations. This recipe provides techniques to help you understand how circular dependencies get created as well as techniques to avoid circular dependencies.
Dealing with circular dependencies
Getting ready
To prepare for this...