Forum Discussion
How to calculate Forecast accuracy
Community ChampionIf you want a MEASURE instead of COLUMN use this the SUMX function is an iterator
ABS Variance MEASURE = SUMX('Table', ABS('Table'[Forecast] - 'Table'[Sold]) )
Accuracy MEASURE = 1 - ( [ABS Variance MEASURE] / SUM('Table'[Forecast] ) )This works with the first example you posted! (You can filter the 'Table' in the SUMX if necessary...)
To get anyone to help you further if this Measure doesn't help you with you actual data
Post sample data that can be copied and pasted into PBI not images!
Otherwise you are asking people to spend the time to recreate your data in order to test it and many will skip over your question
Hello
what if the your data are not in the same table ? you can use the SUMX function
I got one table with forecasts per month per product
one table with sales per month per product
one quick measure to calculate per row the gap / delta
one measure to measure the accuracy at row level.
But i run into same issue to agregate at region or country level
i keep looking. if I found i will share with everyone. In the meantime, if you all ready have the solution, thanks
Hello
Did you find the solution ?
Best regards