Average Accuracy by Month

[Anonymous]

Hi All,

I am looking to calculate an average forecasting accuracy by month. I have created the following measure which works as expected (see results in pic below)

Forecasting Accuracy = 

        AVERAGEX(
            VALUES(Dim_Date[Month]),
            [Variance % - Forecast to Actuals]
        )

However I am looking to create an average of this accuracy across the 12 months. I have placed a CALCULATE around the measure however this doesn't appear to work. I am trying to get the 69.49% in the total to appear in each months column.

Average Forecasting Accuracy = 
    CALCULATE(
        AVERAGEX(
            VALUES(Dim_Date[Month]),
            [Variance % - Forecast to Actuals]
        ),
    ALL(Dim_Date[Month])
)

Many thanks

[Ashish_Mathur · Accepted solution]

Hi,

Problem solved.  You may download my PBI file from here.

Hope this helps.