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