Hi @Matteo-Italy. As with most things in Power BI, there are many ways to solve a problem. Here’s one:
Sales WTD =
VAR _CurrentDate = SELECTEDVALUE( Dates[Date] )
VAR _CurrentWeekYear = SELECTEDVALUE( Dates[Week & Year] )
RETURN
CALCULATE(
[Total Sales],
FILTER(
ALL( Dates ),
Dates[Week & Year] = _CurrentWeekYear &&
Dates[Date] <= _CurrentDate
)
)
Hope this helps.
Greg