Calculated Column Using Measures

[anshpalash]

Hi,

I have a calculated column of the form, E = a*b*c

where a,b,c, are measures. However, the calculation is not considering a. It is just calculating b*c. What can be a reason for this?

[v-angzheng-msft]

Hi, @anshpalash 

Due to the influence of context and other factors, the calculation of measures may not be able to get the correct calculated column. This cannot be explained here.
You can change the measure to a calculated column, and then use the calculated column to multiply to get a new calculated column. Or you may get the correct calculated column by using the calculated table.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HotChilli]

The simple answer is don't use measures to make a calculated column.  Not recommended.