Forum Discussion

rjeffers's avatar
rjeffers
New Member
8 years ago
Solved

Running Sum

Hello all,   Hoping someone can help me out with this. I've created a measure called 'Delta. Calculated as DELTA = SUM(TABLE[WARRANTYUNITS]) - CALCULATE([AVG.WARR.]),ALL(TABLE))   AVG.WARR. is ...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi rjeffers,

     

    You can try to use below mesure to calcualte running total:

    CUSUM =
VAR AVG =
    SUMX ( ALL ( TABLE ), [WARRANTYUNITS] ) / 12
RETURN
    SUMX (
        FILTER ( ALLSELECTED ( TABLE ), [MONTH] <= MAX ( [MONTH] ) ),
        [WARRANTYUNITS]
    )
        - AVG * COUNTROWS ( VALUES ( TABLE[MONTH] ) )

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi rjeffers,

 

You can try to use below mesure to calcualte running total:

CUSUM =
VAR AVG =
    SUMX ( ALL ( TABLE ), [WARRANTYUNITS] ) / 12
RETURN
    SUMX (
        FILTER ( ALLSELECTED ( TABLE ), [MONTH] <= MAX ( [MONTH] ) ),
        [WARRANTYUNITS]
    )
        - AVG * COUNTROWS ( VALUES ( TABLE[MONTH] ) )

 

Regards,

Xiaoxin Sheng