Strange circular dependency issue

Question

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)&nbsp;I have no idea where is the connection between LE to-go (TG LE) and Plan to-go.

amitchandak · Answer

Alanlu , In case both, are columns try 
&nbsp;
[Le] - [CY Rev]

alanlu · Answer

amitchandak&nbsp;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 · Answer

Alanlu , Please share the formula 
Also, Refer
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

alanlu · Answer

amitchandak&nbsp;the formula for TG(Plan) is belowTG (Plan) = CALCULATE(SUM('sales'[AOP])-CALCULATE(SUM('sales'[CY rev])))I tried the formula for TG(LE) as belowTG (LE) = CALCULATE(SUM('sales'[LE])-CALCULATE(SUM('sales'[CY rev])))&nbsp;it did mentioned similar in the video but I cannot add 'allexcept' in the formula, so maybe should try some ways?&nbsp;This is all the columns I have in the table&nbsp;&nbsp;

Forum Discussion

Strange circular dependency issue

4 Replies

Related content

Circular dependency

Circular Dependency

DAX Help - Circular Dependency

Circular Dependency Error

A Circular Dependency was detected