Sales-LWTD = 

CALCULATE( [Total Sales]), 
	FILTER( ALL( 'Calendar'),
	'Calendar'[Week Rank] = ( MAX ('Calendar'[Week Rank]) -1) && 
	'Calendar'[Weekday] <= < MAX( 'Calendar'[Weekday])
		)
	)