YTD sales per week by Reseller using ISO Week Number

[ren_steffen]

I am trying to calculate YTD sales per week for each reseller based on ISO WeekNumber. I have tried various measures and calculated columns such as

YTDTest1 = CALCULATE( SUM( ResellerSales[NetSales] ), FILTER( ALL( ResellerSales ), ResellerSales[WeekNumberISO] = ResellerSales[WeekNumberISO]-1 ) )

Is this possible get YTD updated for each WeekNumber per Reseller? I chose not to use a date field because based on week number. Would consider creating a Date Dimension if that will make this easier. My data looks like this ResellerId WeekNumber ISO WeekNumber Year ISO NetSales Calc Reseller YTD Calc NetSales Weekly Rank 1 50 2019  $             392.01     1 51 2019  $             681.38     1 52 2019  $             350.47     1 1 2020  $             141.55     1 2 2020  $             764.44     1 3 2020  $               85.25     22 50 2019  $             767.09     22 51 2019  $             495.98     22 52 2019  $             872.44     22 1 2020  $             630.64     22 2 2020  $             309.46     22 3 2020  $               62.06     34 50 2019  $             269.23     34 51 2019  $             151.98     34 52 2019  $               23.16     34 1 2020  $             762.61     34 2 2020  $             771.34     34 3 2020  $             473.44

[Greg_Deckler]

@ren_steffen Seems like you need to add YEAR filter into your calculation, otherwise you will get weeks in previous years.

[ren_steffen]

With the current CALCULATE and FILTER there is no data returning. Same with adding a YEAR to the filter, and also adding a filter for store.  If I filter to a SELECTEDVALUE( WeekNumber Field), with YEAR, it sums the same number for all years all records.