power bi community

Hi All,

Need your Help....

I am facing circular dependency error while creating calculated colums.

I have create four measures MTD Actual ,MTD Plan ,YTD Actual & YTD Plan and one backend generated colum Flags.

Now I have to calculate varriance MTD and Varriance YTD  with below calculation

YTD varriance = IF(VW_ARC_DETAILED_TRACKER[FLAGS]="POST",DIVIDE(CALCULATE([YTD ACTUAL]),CALCULATE([YTD PLAN]))-1,
1-DIVIDE(CALCULATE([YTD ACTUAL]),CALCULATE([YTD PLAN])))

First one is working fine but second one is giving error of circular dependency.

In case if i create measure instead of colum ,it doesnot allow to use colum (Flags) in calculation.

Thanks in Advance!!!!!!!!