Circular Dependency Issue

[obriaincian]

I have a calculated table that looks like this

Project	Completed Through	Totally Completed	Expected Completion
Proj 1	15
Proj 2	52
Proj 3	35
Proj 4	23
Proj 5	23

Totally Completed & Expected Completion are 2 columns I need to calculate which reference on another

Totally Completed: Completed Through - Expected Completion 

Expected Completion:  Totally Completed - Completed Through 

I am looking for a workaround on how I can get around the curcular dependency issue I'm having

[amitchandak · Accepted solution]

@obriaincian , Expected Completion is already used Totally Completed, so you can not Totally Completed in Expected Completion  column

https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/