Forum Discussion
Sum Of Measure
Anonymous change your measure like this and test
change your measure like this and test Percent Error * Actual = SUMX( SUMMARIZE( Data, Data[SKU], Data[Warehouse]), [Percent Error]*[Actual] )Anonymous
If you want to calculate the sum of the measure just using SUMX.
Percent Error * Actual = SUMX(Table, [Percent Error]*[Actual])
You should always use X function(sumx, averagex,etc) when calculating with measures, the value of each row then can be saved and calculated.
Best,
Paul
Anonymous not sure where you want the final calculation to be, at the total? Based on the screenshot of dataset your provided, what you want output to be?
parry2k thaks for replying, the thing is the following:
my data is divided into date, sku and warehouse, my two measures for obtaing the Abs Error and the Abs Error * Sales are working fine, i need that the total of the column be 64315, and my result is giving me this:
I want to calculate the division of the sum (abs error * sales)/sum(sales), this is how looks like in excel
Anonymous change your measure like this and test
change your measure like this and test Percent Error * Actual = SUMX( SUMMARIZE( Data, Data[SKU], Data[Warehouse]), [Percent Error]*[Actual] )