Forum Discussion

Pablinho's avatar
Pablinho
Icon for Helper I rankHelper 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
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Pablinho is statement below return any value at all?

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

Pablinho's avatar
Pablinho
Icon for Helper I rankHelper I
3 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.