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

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