Aggregated Weighted MAPE and Forecast Accuracy Calculations in Matrix Visual

DAX DAX Calculations
2

Hi @_mk7

According to your “MAPE” denominator definition you must ignore the filter context. But It never happens! You could use the CALCULATE function

CALCULATE (
   [Total Adjusted Sales],
    ALL ( LOCATION[Location] ),
    ALL ( 'ITEM'[Item] ),
    ALL ( AD_WEEK_DATES[Ad Week] )
)

I hope this helps you. I appreciate if you could check the question as answered.

Best!
DJ