I would solve this in the date table with a calculated column, then you’re formulas become very easy.
Here’s the formula I created for this
Current Week =
VAR IsYear = IF( YEAR( TODAY() ) = VALUE( Dates[Year] ), TRUE(), FALSE() )
VAR IsWeek = IF( WEEKNUM( TODAY() ) = Dates[Week Number], TRUE(), FALSE() )
RETURN
IF( AND( IsYear, IsWeek ), TRUE(), FALSE() )
Now that you have this, you can create calculation quite easily for the current week.
Using combination like this.
CALCULATE( SUM( Column ), Current Week = True )
See how you go with these ideas.
Chrs