Forum Discussion

butterscotch's avatar
butterscotch
Icon for Helper II rankHelper II
2 years ago

A circular dependency

Hello Everyone ! im facing an issue where i want to create a column using a measure but an error arise , the issue  the formula for completion Feb Completion Feb = IF( VALUES('Master...
Need Help
butterscotch's avatar
butterscotch
Icon for Helper II rankHelper II
2 years ago

im sorry, but i dont quite understand

gmsamborn's avatar
gmsamborn
Icon for Super User rankSuper User
2 years ago

There is an order of evaluation.  If a calculated column uses a measure that relies on context (filters, slicers), it might work when writing it because the slicer would have a selection (creating context).  On the other hand, when a refresh is being done, there are no slicers or filters active because they aren't evaluated until after the refresh is complete.

 

I hope that makes sense.