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
Microsoft 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

ccakjcrx's avatar
ccakjcrx
Resolver I
8 years ago

v-jiascu-msft

 

Hey!

 

That certainly worked for me. Thank you!

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    You are welcome. ccakjcrx,

     

    Hi ricardobrubaker,

     

    That's one more question. You can try this formula for % forecast.

    % forecast =
SUM ( Table1[Forecast adjusted] )
    / CALCULATE ( SUM ( Table1[Forecast adjusted] ), ALLSELECTED ( Table1[GAMA] ) )

    SUM_a_Measure1

     

    Best Regards,

    Dale