Calculating Active Employees by specific Date

Hello DarshanKumar,

Can you please try this approach:

ActiveEmployeesPerDepartment =
VAR SelectedMonth =
    MAX('Calendar'[Date])
RETURN
CALCULATE (
    DISTINCTCOUNT ( 'Job Information'[Emp ID] ),
    FILTER (
        ADDCOLUMNS (
            SUMMARIZE (
                'Job Information',
                'Job Information'[Emp ID],
                'Job Information'[Department],
                "LatestChange",
                    CALCULATE (
                        MAX ( 'Job Information'[Job Information: Date] ),
                        FILTER (
                            'Job Information',
                            'Job Information'[Emp ID] = EARLIER('Job Information'[Emp ID]) &&
                            'Job Information'[Department] = EARLIER('Job Information'[Department]) &&
                            'Job Information'[Job Information: Date] <= SelectedMonth
                        )
                    )
            ),
            "HireCheck", CALCULATE (
                MIN ( 'Job Information'[Hire Date] )
            ),
            "TermCheck", CALCULATE (
                MAX ( 'Job Information'[Terminaion Date] )
            )
        ),
        [HireCheck] <= SelectedMonth &&
        (ISBLANK([TermCheck]) || [TermCheck] > SelectedMonth)
    )
)