DAX - Running Total on measure by month index (column)

[diskman]

Hi

I have a dynamic table "table" (created by SUMMARIZE function based on other table) with fields:

• "MonthIndex" - column
• "MonthName" - column
• "Forecast%" - measure which depends on some slicer and switch statements

table = 
SUMMARIZE (
    'Calendar New',
    'Calendar New'[Month],
    'Calendar New'[MonthIndex]
    )

I am trying to set up a running total "x" of "Forecast%" by "MonthIndex" but the runing total does not work - see screenshot.

x = CALCULATE (      
   'table'[Forecast%],      
   FILTER (      
      ALL ( 'table'[MonthIndex] ),      
      'table'[MonthIndex] <= MAX ( 'table'[MonthIndex] )  
   )    
)  

Looking for any ideas

regards

[smpa01]

@diskman  any chance you can provide a sample pbix?

[diskman]

@smpa01sorry the pbix has commercial data related 😞

[smpa01]

@diskman  How did you write 

[Forecast%]

[diskman]

@smpa01  it is as below ... AFAIK It must use the measure because there is visual slicer used "Preference %" for measure calculation

Forecast % = (IF(MIN('table'[MonthIndex])=1,'Preference %'[Preference % Value], (33-'Preference %'[Preference % Value])/11))/100

[diskman · Accepted solution]

@smpa01this has worked for me

 x = 
    SUMX(
        FILTER(
            ALL('table'),
            'table'[MonthIndex] <= MAX ( 'table'[MonthIndex] )
        ),
        'table'[Forecast%]
    )