Forum Discussion
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...
Hi butterscotch
Calculated columns are calculated on refresh before any visuals, slicers etc are active. That includes measures as well since they rely on context and there is no context at that point.
Not a best practice.
im sorry, but i dont quite understand
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.