Same formula for calculated column and measure in the same table. Different results. Why?

[gopaltarakad]

Is there any reason why this might happen? My formula is the exact same in both places and the calculated column is included in the same table that the calculated measure is applied to- all using information from the same table. Thanks for your help.

[v-caliao-msft]

Hi @gopaltarakad,

Calculated columns (and tables) are:

- Evaluated for each row in your table, immediately after you hit 'Enter' to complete the formula

- Saved back into the model so take up space

Calculated Measures are:

- Evaluated when you use it in a visual, when the visual is rendered

- Not saved anywhere (well, actually there's a cache in the report layer but it's not part of the file when you hit Save)

As you can see, an simple DAX expression.
CalculatedColumn = sum(CombineA[Score])
CalculatedMeasure = sum(CombineA[Score])

Regards,

Charlie Liao

[ankitpatira]

@gopaltarakad On top of what Eno said you may want to go through this article on understand in-depth how both works. Basic difference between two is but I guess it will be something to do with the filter. If you can provide query for both I can look into it.

[gopaltarakad]

Thanks for your reply. Will check and get back to you.

[Seth_C_Bauer]

@gopaltarakad Outside the obvious, which would be that you have a filter applied to one of the tables. The only other time I've encountered odd behaviour is when I copied a table or visual. For some reason it seemed that there were residual filters or something from the initial visual that was effecting the outcomes. Do you get the same behaviour if you re-create the table that is not showing correctly?

[gopaltarakad]

Thanks for your reply. Will check and get back to you.