Rolling 28 Days Measure

Hello davehus , 

Please us the below modified DAX..

Rolling 4 Week Downtime =
CALCULATE (
SUM ( 'Downtime Table'[Downtime] ),
FILTER (
ALL ( 'Downtime Table'[ProductionDate] ),
'Downtime Table'[ProductionDate] >=MAX ( 'Downtime Table'[ProductionDate] ) - 28 &&
'Downtime Table'[ProductionDate] <=MAX ( 'Downtime Table'[ProductionDate] )),
REMOVEFILTERS('Date Table'[Week Slicer]))

1. MAX instead of SELECTEDVALUE: This ensures the rolling window is calculated based on the most recent production date, regardless of slicer filters.

2. Range Filter: I’ve added a <= MAX() condition to ensure that only the dates within the last 28 days are summed.

3. Filter on All Production Dates: ALL removes existing filters on the date column to correctly apply the rolling logic.

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

Thank You

Dharmendar S

LinkedIN