Incorrect Totals in Power BI Table for MAPE

Question

I have tried to calculate Mean Average Percentage error by using the following measure:

[ABS(Actuals - Forecast)/Actuals]

For the following data

I want the total should be around 5.88 but it is showing 0.52,

How can i resolve it? 

Answer 1

Use the following measure:

VAR _mytable = SELECTCOLUMNS(FactTable, "MAPE", ABS(Actuals - Forecast)/Actuals)) Return Sumx(_mytable, [MAPE])

Want to learn more about Power BI? Check out today: Power BI course