Help with Date Filter needed

Hi ArchStanton ,

The issue arises because you're using ResolutionTable[Date] in your TOTALYTD calculation, but the actual resolution dates of the cases are in the 'Cases'[Resolution Date] column. Unless there's an active one-to-many relationship between 'Cases'[Resolution Date] and ResolutionTable[Date], the date filter context won't propagate correctly, leading to duplicated April values. The measure that gave you correct results—YTD Closed Cases 3—works because it references the resolution date column directly but only works when a page-level filter is applied.

To solve this and remove the dependency on a page filter, modify the measure to embed the resolution date condition directly within the CALCULATE function. Use the version below to count only resolved cases with resolution dates after 31 March 2025, applying the correct year-to-date logic.

YTD Closed Cases Fixed = 
CALCULATE(
    TOTALYTD(
        COUNT('Cases'[Case Number]),
        'Cases'[Resolution Date],
        "31/03"
    ),
    'Cases'[statecode] = "Resolved",
    'Cases'[Resolution Date] > DATE(2025,3,31)
)

If you need to continue using the calendar table for consistency, ensure there's an active relationship between 'Cases'[Resolution Date] and ResolutionTable[Date]. Then the following version will also work without requiring an external filter:

YTD Closed Cases Using Calendar = 
CALCULATE(
    TOTALYTD(
        COUNT('Cases'[Case Number]),
        ResolutionTable[Date],
        "31/03"
    ),
    'Cases'[statecode] = "Resolved",
    'Cases'[Resolution Date] > DATE(2025,3,31)
)

This approach avoids duplicated values and gives you the correct output directly from the measure.

Best regards,