Forum Discussion

ricardobrubaker's avatar
ricardobrubaker
Frequent Visitor
8 years ago

SUM a Measure

Hello,    I have the following dataset:      MAPE UNITS = (sales-forecast)/Sales % forecast= Forecast/Sum Forecast WMAPE Units = MAPE UNITS * % FORECAST   The issue is that the Total o...
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi ricardobrubaker,

 

Try this formula please.

Measure 2 =
SUMX (
    SUMMARIZE (
        'Table1',
        'Table1'[Year Week],
        'Table1'[GAMA],
        'Table1'[Sales],
        'Table1'[Forecast adjusted],
        "temp", [Mape Units] * [% forecast]
    ),
    IF ( ISERROR ( [temp] ), 0, [temp] )
)

SUM_a_Measure

 

Best Regards,

Dale

ricardobrubaker's avatar
ricardobrubaker
Frequent Visitor
8 years ago

Hi Dale,

 

Thanks for the help, unfourtunately that is not working: 



Also, your % forecast is incorrect as it should sum to 100%.

For your first column, your % forecast should be 2571/2868 = 89%

 

Thanks anyways! 

Ricardo BRubaker