Need Periodical count of employees by his manager

[Danthe-Nagaraju]

I am Struggling to get periodical count of employees, based on the Functional Manager and week Number
The example table

Week Number	Employees.Id	Fullname	Functional Manager	Startdate	Termination Date	Employment Status
41	1416	Amir	William	7/1/2022 0:00		Active
41	1489	Anand	Mahesh	9/12/2022 0:00		Active
41	1505	Santosh	Pradeep	10/10/2022 0:00		Active
41	1506	Vineth	William	10/10/2022 0:00		Active
41	1507	John	Mahesh	10/10/2022 0:00		Active
41	1508	Praneeth	Pradeep	10/12/2022 0:00	10/14/2022 0:00	Inactive
41	1509	Thomas	William	10/12/2022 0:00		Active
42	1416	Amir	William	7/1/2022 0:00	10/29/2022 0:00	Inactive
42	1489	Anand	Mahesh	9/12/2022 0:00	10/25/2022 0:00	Inactive
42	1505	Santosh	Pradeep	10/10/2022 0:00		Active
42	1506	Vineth	William	10/10/2022 0:00		Active
42	1507	John	Mahesh	10/10/2022 0:00		Active
42	1509	Thomas	William	10/12/2022 0:00		Active
43	1505	Santosh	Pradeep	10/10/2022 0:00		Active
43	1506	Vineth	William	10/10/2022 0:00		Active
43	1507	John	Mahesh	10/10/2022 0:00		Active
43	1509	Thomas	William	10/12/2022 0:00		Active

Need to know the Count of employees By week wise 41,42,43 howmany employees are reporting to William, Mahesh and Pradeep so on dynamically.
I hope I can get help.

[Danthe-Nagaraju]

Hi Jihwan,
Thanks for the concern
i need the total count of employees who are reporting to the certain person for certain week.

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

I suggest having a calendar table like the attached file.

Please check the below picture and the attached pbix file.

Count of active employee: = 
COUNTROWS (
    FILTER (
        Data,
        Data[Startdate] <= MAX ( 'Calendar'[Date] )
            && OR ( Data[Termination Date] >= MIN ( 'Calendar'[Date] ), BLANK () )
    )
)