Calculate Non-Rolling 13 Week SUM

Hi v-lid-msft ,

I've copied your formula to my PBI file and interestingly the 13 Week Confirmation Rate formula is calculating the same result as my YTD Confirmation Rate formula.. See below the formulas, and let me know if you see anything wrong with mine..

YTD Confirmation Rate = 
DIVIDE(
    SUM(‘table 2’[Confirmed Quantity]),
    SUM(‘table 2’[Order Quantity])
)

Non-rolling 13 WK Confirmation Rate = 
Var t = 
    ADDCOLUMNS (
        ALLSELECTED( ‘table 2’),
        "WeekIndex", RANKX ( ALLSELECTED ( ‘table 2’ ),[Week of Year],, DESC )
        )
Var i =
    MAXX (
        FILTER ( t , ‘table 2’ [Week of Year] = MAX (‘table 2’ [Week of Year] ) ),
        [WeekIndex] 
        )
RETURN
    CALCULATE (
        SUM (‘table 2’ [Confirmed Quantity] ),
        FILTER ( t, [WeekIndex] <= i + 12 && [WeekIndex] >= i )
        )
        / CALCULATE (
            SUM (‘table 2’ [Order Quantity] ),
            FILTER ( t, [WeekIndex] <= i + 12 && [WeekIndex] >= i )
        )

I think the problem might be because I have filters on the report that I didn't previously mention, since I didn't think they would effect the formula.. I have the below slicer filters used on this report.. to help clarify, blue is what the 13 Week Confirmation table should calculate for, and red is what the measure should not calculate for.

Material

Abc123 (filtered on)

Abc234 (filtered out)

Abc345 (filtered out)

Abc456 (filtered out)

Year

2018 (filtered out)

2019 (filtered on)

Are there any filter [material] or [year] formulas I need to add to your formula to make mine work? for example, see below. I thought I could get away with the simplified excel table example, but here it is more complicated.

Appreciate the help.. very close to solving this problem.

Kordel