Employee T/O measures

Question

Hi I need some help - I am doing a dashboard and one of the things I need to do is get the T/O percentage of employees who have resigned by average current employees - this is what I have got so far&nbsp;Resignation T/O = ([Count Resignations]/[Avg current employees]*100 )&nbsp; [Count Resignations is the count of employees who have left because they have resigned&nbsp; &nbsp;&nbsp;&nbsp;Count Resignations = CALCULATE(&nbsp;&nbsp;&nbsp;&nbsp;COUNT(Personnel_Records[Resignation]),&nbsp;&nbsp;&nbsp;&nbsp;FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Personnel_Records',&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Personnel_Records'[Resignation] = 1 &amp;&amp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Personnel_Records'[Leaving Date] &gt; DATE(2021, 1, 1)&nbsp; and Avg current employees is :&nbsp;Avg current employees = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AVERAGEX(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUES('Date'[Month]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Current Employees])&nbsp;I am not sure I have this right and would like some feedback.&nbsp; Many thanks

michalison · Answer

Yes I will try this and see if there is a difference thank you

fowmy · Answer

Michalison&nbsp;Without data and the expected results, it a bit hard to propose a solution. any how can you try this and revert.
CountResignations =
VAR _DATE =
    DATE ( 2021, 1, 1 )
RETURN
    CALCULATE (
        COUNTROWS ( Personnel_Records ),
        'Personnel_Records'[Resignation] = 1,
        'Personnel_Records'[Leaving Date] &gt; _DATE
    )

&nbsp;

anonymous · Answer

Looks correct, Did you test with some data ?&nbsp;

michalison · Answer

Yes I did and I think it is correct only it is not showing as percentages and as I am teaching myself I was not confident I had done it correctly - below is the chart&nbsp;&nbsp;&nbsp;

anonymous · Answer

There is an option to show values as %, Did you try that ?&nbsp;

Forum Discussion

Employee T/O measures

8 Replies

Related content

Missing employee

Counting Active employees per month

Related employees via bridge

Enhancement Request – Add Visit Frequency Count to Employee Location Measure

Employee retention data