Forum Discussion

pointer's avatar
pointer
New Member
9 years ago
Solved

Circular Dependency

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])
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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