Circular Dependency

[pointer]

Hey

having those two columns I get a Circular Dependency error and I don't know how to fix it.

Can you yelp?

Achieved = TOTALYTD(SUM(VIEW[Sales]);VIEW[Date].[Date])
Cumulative Target = TOTALYTD(SUM(VIEW[Quantity])*100;VIEW[Date].[Date])

[v-shex-msft · Accepted solution]

Hi @pointer,

There columns will calculated through the date column, I think the issue may related to it.

You can try use below formula to use other functions calculate YTD.

Cumulative Target = CALCULATE(SUM(VIEW[Quantity])*100;FILTER(ALL(View),[Date].[Year]=EARLIER(View[Date].[Year])&&[Date]<=EARLIER(View[Date])))

In addition, you can try to use measure to instead the calculated column.

Regards,

Xiaoxin Sheng

[pointer]

Thank you very much!