Strange circular dependency issue

[Alanlu]

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 sales (AOP - CY rev)

I have no idea where is the connection between LE to-go (TG LE) and Plan to-go.

[amitchandak]

@Alanlu , In case both, are columns try

[Le] - [CY Rev]

[Alanlu]

@amitchandak It's not working as I expected.

maybe I should explain a bit more regarding the format of the data.

[CY rev] contains multiple posting dates and customer#

[AOP] and [LE] are allocated monthly only.

I would like to see the to-go value va AOP and LE for MTD, QTD and YTD.

Thanks

[amitchandak]

@Alanlu , Please share the formula

Also, Refer

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

[Alanlu]

@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