Moving average with custom calendar

I am having trouble creating rank in the first place. I am getting the below error. 

A single value for column 'fiscalweeknumber' in table 'Summaryold' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.