Date Filter not working Rolling Dates Calculation

[Rasperskaap]

We are trying to calculate sales over differing rolling periods given the maximum date in the dataset - I have tried multiple formula but in each case when you set the start date equal to a formula the calculation is not correct - take a look at the following examples for a rolling 7 day calculation Working - Past 7 Day Bill Count = CALCULATE(DISTINCTCOUNT('rep SaleDailyTurnOver'[SaleID]), FILTER ( ALL ( 'rep SaleDailyTurnOver'[SaleDate] ), 'rep SaleDailyTurnOver'[SaleDate] >= DATE(2016,8,21) && 'rep SaleDailyTurnOver'[SaleDate] <= MAX ( 'rep SaleDailyTurnOver'[SaleDate] ) ) ) Not working - Past 7 Day Bill Count = CALCULATE(DISTINCTCOUNT('rep SaleDailyTurnOver'[SaleID]), FILTER ( ALL ( 'rep SaleDailyTurnOver'[SaleDate] ), 'rep SaleDailyTurnOver'[SaleDate] >= (MAX ( 'rep SaleDailyTurnOver'[SaleDate] ) - 7) && 'rep SaleDailyTurnOver'[SaleDate] <= MAX ( 'rep SaleDailyTurnOver'[SaleDate] ) ) ) We also did something similar for the datesbetween function in the calculation, with similar results - Past 7 Day Bill Count = CALCULATE(DISTINCTCOUNT('rep SaleDailyTurnOver'[SaleID]), DATESINPERIOD('rep SaleDailyTurnOver'[SaleDate], LASTDATE('rep SaleDailyTurnOver'[SaleDate]), -7, DAY))