Whenever there are DAX circular dependency errors in Power BI DAX expressions, you can apply some pragmatic ways to avoid them.
Separate Calculations: First, separate calculations that could impact each other. Instead of piling on measures to already existing ones, create independent intermediate measures. This way, the cycle is broken, and each calculation depends on an already completed and stable result.
Utilize Variables: A word on variables in DAX (VAR statements): These are vital in controlling dependencies. Quite often, intermediate results are estimated within a single measure to avoid estimating several dependent calculated columns. Variables are only computed once and kept in memory, hence minimizing circular reference.
Rethink Dependencies: Reorganize the model where appropriate to avoid redundant dependencies. Rather than stacking calculations, it may be more prudent to merge some or all of them into a single measure. In case of multiple calculations, eliminate any that are the same to lessen the dependence of the others.
Check Filter Context: Complex filter contexts can also cause circular dependencies. Shape your measures properly with respect to row-level filters, and consider using REMOVE FILTERS or ALL functions to handle complex dependencies within calculated columns or measures.
For more information, check this link: https://community.fabric.microsoft.com/t5/Desktop/Circular-dependency/td-p/2964191
