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 = TOTA...
  • 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

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

  • pointer's avatar
    pointer
    New Member
    9 years ago

    Thank you very much!