Forum Discussion
Sum Of Measure
Hello Everyone! I am trying to calcule KPI wich is called WMAPE, my data is like the picture bellow, I have the following formulas: 1. Percent Error = ABS ( DIVIDE ( SUM ...
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?