Forum Discussion
Error: circular dependency
I assume these are calc columns, is that correct? I am aware of a circular dependency "issue" when you write multiple calc columns, and their incrementally refer to all columns in a table. It is very complex and I don't think I can explain it based on what I see. But my suggestion is that you don't write calc columns at all, but instead write measures. Read my article about the difference here. http://exceleratorbi.com.au/calculated-columns-vs-measures-dax/
I assume these are calc columns, is that correct? I am aware of a circular dependency "issue" when you write multiple calc columns, and their incrementally refer to all columns in a table. It is very complex and I don't think I can explain it based on what I see. But my suggestion is that you don't write calc columns at all, but instead write measures. Read my article about the difference here. http://exceleratorbi.com.au/calculated-columns-vs-measures-dax/
In my case If i create measure instead of colum ,it doesnt allow colum name ( (VW_ARC_DETAILED_TRACKER[FLAGS]) into measure.
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])))
Please help..Thanks in advance !!!!!!!