Assistance with Date Filters

Hi AmandaHore ,

You can create a measure with output as 0 or 1 for your conditions and then use it as a visual-level filter:

Is Active in Period = 
VAR PeriodStart = MIN('Date'[Date])  // The start date from your slicer
VAR PeriodEnd   = MAX('Date'[Date])  // The end date from your slicer
VAR EmpStart    = SELECTEDVALUE('User Posting'[Start Date])
VAR EmpEnd      = SELECTEDVALUE('User Posting'[End Date])

RETURN
// Logic: An employee is active if they started before the period ended...
// ...AND (they are still active OR they left after the period started).
IF (
    EmpStart <= PeriodEnd && 
    (ISBLANK(EmpEnd) || EmpEnd >= PeriodStart),
    1,
    0
)

Please give kudos or mark it as a solution once confirmed.

Thanks and Regards,

Praful