Forum Discussion

Pablinho's avatar
Pablinho
Helper I
3 years ago

Circular dependency when using calculated column

Hello!   This is my scenario. I have one table with % rates for different terms. My goal is to display a line graph that shows how the rate increases over time. So, if the rate in the first term wa...
calcualted column
Circular dependency
error
Help
some_bih's avatar
some_bih
Community Champion
2 years ago

Hi Pablinho try the last part 

CALCULATE(sum(Masterfile[Awarded]),Masterfile[STATUS]="GRD") * 100 

put into variable and this replace in ActualRate.  

Pablinho's avatar
Pablinho
Helper I
2 years ago

Hello.

 

Thanks for the reply. I did the change to the ActualRate column, but the error persists. This is how the ActualRate column looks now:

ActualRate =
VAR _actualRate = CALCULATE(sum(Masterfile[Awarded]),Masterfile[STATUS]="GRD") * 100 
RETURN if(
    _actualRate = 0,
    0,_actualRate)
 
Thank you.
  • some_bih's avatar
    some_bih
    Community Champion
    2 years ago

    Hi Pablinho is statement below return any value at all?

    CALCULATE(sum(Masterfile[Awarded]),Masterfile[STATUS]="GRD") * 100 

    • Pablinho's avatar
      Pablinho
      Helper I
      2 years ago

      Yes, it gives the correct value but only for the ActualRate column. The error comes from the Result column when I try to use the ActualRate column value instead of the Rate one.