Adjusted Comp. Requests Amount = VAR CurrentPeriod = VALUES ( 'Date'[Date] ) VAR ComparisonPeriod = CALCULATETABLE ( VALUES ( 'Date'[Date] ), REMOVEFILTERS ('Date'), USERELATIONSHIP ('Date'[Date], 'Comparison Date'[Comparison Date] ) ) VAR ComparisonSales = CALCULATE ( "Measure" }, ComparisonPeriod ) VAR DaysInCurrentPeriod = COUNTROWS ( CurrentPeriod ) VAR DaysInComparisonPeriod = COUNTROWS ( ComparisonPeriod ) VAR DailyComparisonSales = DIVIDE ( ComparisonSales, DaysInComparisonPeriod ) VAR Result = DaysInCurrentPeriod * DailyComparisonSales RETURN Result