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
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] )