How to calculate the YTD attrition

[Anonymous]

Dear Community: We have "Employee Status" whether they are active or terminated in one column and we have "Employment Details Termination Date" in another. Please help me to calculate the YTD attrition %. 

Global ID	Employee Status	Fourth Level	Country/Region	Employment Details Termination Date
1	Active	Compositing	India	Sunday, May 8, 2022
2	Active	Compositing	India	Friday, April 15, 2022
3	Active	Animation	India	Sunday, June 19, 2022
4	Active	Tech Anim	India	Saturday, April 9, 2022
5	Terminated	Compositing	India	Sunday, April 24, 2022
6	Terminated	FX	India	Sunday, May 1, 2022
7	Terminated	Compositing	India	Friday, April 15, 2022
8	Terminated	Assets	India	Friday, April 22, 2022
9	Terminated	Assets	India	Sunday, April 10, 2022
10	Terminated	FX	India	Friday, April 15, 2022
11	Terminated	Lighting	India	Saturday, May 7, 2022
12	Terminated	Animation	India	Saturday, May 28, 2022
13	Terminated	Compositing	India	Saturday, May 21, 2022
14	Terminated	Paint Prep	India	Tuesday, April 19, 2022
15	Terminated	Compositing	India	Sunday, May 8, 2022
16	Terminated	Paint Prep	India	Thursday, June 16, 2022
17	Terminated	Assets	India	Saturday, April 23, 2022
18	Terminated	Animation	India	Monday, May 9, 2022
19	Terminated	Paint Prep	India	Saturday, May 28, 2022
20	Terminated	Animation	India	Monday, May 2, 2022
21	Terminated	Animation	India	Tuesday, May 17, 2022
22	Terminated	Animation	India	Wednesday, June 8, 2022
23	Terminated	Compositing	India	Saturday, April 23, 2022
24	Active	FX	India	Sunday, May 1, 2022
25	Active	Animation	India	Monday, April 18, 2022
26	Active	3D DMP	India	Saturday, May 21, 2022
27	Active	Paint Prep	India	Thursday, April 21, 2022
28	Active	Compositing	India	Saturday, May 28, 2022
29	Active	Rotoscope	India	Sunday, April 17, 2022
30	Active	Animation	India	Saturday, June 4, 2022
31	Active	Compositing	India	Tuesday, May 31, 2022
32	Active	Assets	India	Sunday, May 1, 2022
33	Active	Rotoscope	India	Tuesday, April 5, 2022
34	Active	Compositing	India	Saturday, April 23, 2022

Any help will be much appreciated. Thanks in advance!

[Anonymous · Accepted solution]

Hi @Anonymous ，

I think you can try this code.

YTD attrition % =
VAR _TOTAL =
    CALCULATE ( COUNT ( 'Table'[Global ID] ), ALL ( 'Table' ) )
VAR _Terminated =
    CALCULATE (
        COUNT ( 'Table'[Global ID] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Employee Status] = "Terminated" )
    )
RETURN
    DIVIDE ( _Terminated, _TOTAL )

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.