Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cumulative Sum using DAX

Hi All,   I have my data as below.   ID OUTPUT_TYPE FORECASTED_MONTH FORECAST_QTY Cumm. FORECAST_QTY 1 NOMINAL 3 26 26 1 NOMINAL 6 27 54 1 NOMINAL 9 28 82 1 NOMINA...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try like

    Cummulative Qty New =
    CALCULATE(
    SUM('Forecasting'[FORECAST_QTY]),
    FILTER(
    allselected('Forecasting'),'Forecasting'[ID],'Forecasting'[OUTPUT_TYPE] max('Forecasting'[OUTPUT_TYPE]) &&
    'Forecasting'[FORECAST_MONTH] <= MAX('Forecasting'[FORECAST_MONTH])
    )
    )

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Hello good afternoon I am in a dilemma here the %TO Voluntary I get 9.05% the total but when I want to show in graph I get a lower value 8.1. what I must do so that when I make a graph I get the correct total % .

I put the image of the graph that does not match the total quantities.

Please support.