Forum Discussion

Axel_hnk's avatar
Axel_hnk
Frequent Visitor
4 years ago

SUMX Problem with Forecast % on Certain Level

Hi there, I basically want to calculate a forecast for a current MTD Value for a product till the end of the month. The problem: Although I am using SUMX / VALUES the aggregation/totals are not cons...
Need Help
v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Axel_hnk ,

 

Please try the following generic measures for calculating total value.

 

Measure = 
SUMX ( VALUES ( 'Product_Table'[Product_Category& Subcategory] ), [Forecast_Measure] )

Or

Measure =
SUMX (
    SUMMARIZE (
        'Product_Table',
        'Product_Table'[Product Category],
        'Product_Table'[Product_Category& Subcategory],
        "_Forecast", [Forecast_Measure]
    ),
    [_Forecast]
)

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.