Avoiding circular dependency errors in DAX
This article explains how DAX handles dependencies between tables, columns and relationships, to help you avoid circular dependency errors.
If you work with Power BI data models, you create relationships between tables quite often. When building complex DAX code or creating calculated tables, you might encounter the problem of circular dependency errors as shown in the next figure: