Changing the filter context for calculating cummulative values

Thanks for the reply from lbendlin , please allow me to provide another insight:

Hi, Ed212 

According to our security protocols, I am currently unable to download the latest PBIX sample data you provided. However, I have obtained the sample data provided by lbendlin .

Regarding the issue you raised, my solution is as follows:

1.Considering your need to use a slicer, I created the following calculated column to perform cumulative addition:

run1 = 
VAR cy = 'example'[YearNumber]
VAR cw = 'example'[WeekNumber]
VAR aa2 =
    CALCULATE (
        SUM ( 'example'[Quantity Sold] ),
        FILTER (
            ALLSELECTED ( 'example' ),
            'example'[YearNumber] = cy - 1
                && 'example'[Product] = EARLIER ( 'example'[Product] )
        )
    )
VAR aa3 =
    IF (
        'example'[WeekNumber] = MIN ( 'example'[WeekNumber] ),
        'example'[Quantity Sold] + aa2,
        'example'[Quantity Sold]
    )
RETURN
    aa3

run2 = 
CALCULATE (
    SUM ( 'example'[run1] ),
    FILTER (
        ALLSELECTED ( 'example' ),
        'example'[Product] = EARLIER ( 'example'[Product] )
            && 'example'[YearNumber] = EARLIER ( example[YearNumber] )
            && 'example'[WeekNumber] <= EARLIER ( example[WeekNumber] )
    )
)

2.Next, I used the following measure to control the display content:

MEASURE = 
IF (
    ISINSCOPE ( 'example'[YearNumber] ),
    IF (
        ISINSCOPE ( example[WeekNumber] ),
        SUM ( 'example'[run2] ),
        SUM ( 'example'[run1] )
    ),
    CALCULATE (
        SUM ( example[run1] ),
        FILTER (
            ALLSELECTED ( 'example' ),
            'example'[YearNumber] = MAX ( 'example'[YearNumber] )
        )
    )
)

3.Here's my final result, which I hope meets your requirements.

4.For questions about uploading data, you can try the following links:

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Solved: How to upload PBI in Community - Microsoft Fabric Community

Please find the attached pbix relevant to the case.

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.