Forum Discussion
Calculate MAPE based on Absolute Percentage Error
Hi there We have a requirment to use statistics to show the MAPE for a user on how well their Electricity Usage correlates with the Moving Average of what we estimate they should use. To get ...
Conscious the original post was from 2018 but we recently had a similar challenge and struggled to find an answer in the forums.
We solved this issue by referencing the current measure (ABS_PCT_ERR) within a new measure using AVERAGEX and SUMMARIZE.
New measure = AVERAGEX ( SUMMARIZE ( DATE Table, DATE Column , "ColumnName123" , [ABS_PCT_ERR] ) , [ColumnName123] )
This should give you the same results in each row of your table visual, but give you an average at the bottom.