Calculate the cumulative (running total) in column, not measure

[naoyixue1]

Hey there,

I tried to calculate the running total based on the % at SKU level. Then I can categorize A,B,C items. But my calculation doesn't work. Do you have any thoughts? Thanks. ( I need the calculation added in column, not measure). 

[naoyixue1]

@ChrisMendoza  Thank you so much!

[ChrisMendoza · Accepted solution]

@naoyixue1 - Are you trying to do this? 

RT Item level % = 
VAR maxWeek = 'Table'[Week]

RETURN 
    CALCULATE(
        SUM('Table'[Item level %]),
        ALLEXCEPT('Table','Table'[SKU]),
        'Table'[Week] <= maxWeek
    )