Forum Discussion
Calculated column giving incorrect values
Anonymous
It's not so much about changing the model but more about how context transition in this case works. To know what your measure will calculate when used in a column, you have to understand exactly how it'll interact with the row context. Also, you should avoid creating a calculated column in a fact table like the plague. Such a need can be efficiently and correctly addressed in Power Query.
A measure used in a calculated column does context transition, so you have to figure out how this context is propagated throughout the model to be able to explain the figure you get.
I tried createing a measure by skightly changing the model and I still get incorrect result
Anonymous
It's not so much about changing the model but more about how context transition in this case works. To know what your measure will calculate when used in a column, you have to understand exactly how it'll interact with the row context. Also, you should avoid creating a calculated column in a fact table like the plague. Such a need can be efficiently and correctly addressed in Power Query.