HR dashboard

Hi maryam_arif28 ，

First, could you please provide the logic for calculating head count, female employee and Male employee? Which table does the gender information of the employee exist in? If there are no other special filter conditions, and assuming the employee gender information is in the employee card table, you can create the following three measures to achieve this. Please find the details in the attachment.

HR Dashboard Help - HC numbers

Headcount = 
VAR _seldate =
    SELECTEDVALUE ( 'Date'[Date] )
RETURN 
    CALCULATE (
        DISTINCTCOUNT ( 'employee master'[Employee ID] ),
        FILTER (
            'employee master',
            'employee master'[Employment Date] <= _seldate
                && (ISBLANK('employee master'[Termination Date])||('employee master'[Termination Date] > _seldate))
        )
    )

female employee = CALCULATE([Headcount],FILTER('employee card','employee card'[Gender]="Female"))

Male employee = CALCULATE([Headcount],FILTER('employee card','employee card'[Gender]="Male"))

If the measures given above do not meet your needs, please provide sample data from the four tables, the calculation logic and the final result you want to obtain. Thank you.

Best Regards