Forum Discussion
anomaly in results from Measure vs Calculated column
Hi guys, I have a measure called Total Sales and table function TOPN as below with a calculated column as totSales, Measure: Total Sales = SUMX( Sales, Sales[Quantity] * RELATED( Products[Curre...
Ashish_Mathur
Super User
Super UserHi,
What exactly are you trying to accomplish? Why are you referring to a measure in a calculated column formula?
Hi Ashish_Mathur ,
I'm new to Power BI and trying things may not be correct.
In this case, a comparison of calculated column and measure results is confusing me. I noticed the difference in result without trying to build or do anything purposefully.
You may have a point asking, "referring to a measure in a calculated column", is this where the anomaly is happening? if yes, could you elaborate further please?