Forum Discussion
Strange circular dependency issue
Hi guys, I have encountered some strange circular dependency error which I do not see any connection between each section. TG (Plan) has already been calculated using plan number - current sa...
Alanlu , Please share the formula
Also, Refer
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
amitchandak the formula for TG(Plan) is below
TG (Plan) = CALCULATE(SUM('sales'[AOP])-CALCULATE(SUM('sales'[CY rev])))
I tried the formula for TG(LE) as below
TG (LE) = CALCULATE(SUM('sales'[LE])-CALCULATE(SUM('sales'[CY rev])))
it did mentioned similar in the video but I cannot add 'allexcept' in the formula, so maybe should try some ways?
This is all the columns I have in the table