Sales-CW =
CALCULATE( [Total Sales],
FILTER(
ALL('Calendar'),
'Calendar'[Week Rank] = MAX( 'Calendar'[Week Rank])
)
)
Sales-CW =
CALCULATE( [Total Sales],
FILTER(
ALL('Calendar'),
'Calendar'[Week Rank] = MAX( 'Calendar'[Week Rank])
)
)