Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Michalison
Helper II
Helper II

Employee T/O measures

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

 

Resignation T/O = ([Count Resignations]/[Avg current employees]*100 )  [Count Resignations is the count of employees who have left because they have resigned    
 
Count Resignations = CALCULATE(
    COUNT(Personnel_Records[Resignation]),
    FILTER(
        'Personnel_Records',
        'Personnel_Records'[Resignation] = 1 &&
        'Personnel_Records'[Leaving Date] > DATE(2021, 1, 1)  and Avg current employees is :
 
Avg current employees =
    
    AVERAGEX(
         VALUES('Date'[Month]),
            [Current Employees]
)
 
I am not sure I have this right and would like some feedback.  Many thanks
8 REPLIES 8
kp54357
Helper I
Helper I

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

 

No I couldnt find an option that allows you to change it to percentages

Pls use this option :

kp54357_0-1638881383193.png

 

Sorry cant find there anywhere

kp54357
Helper I
Helper I

Looks correct, Did you test with some data ?

 

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 

 

Michalison_0-1638880150098.png

 

Fowmy
Super User
Super User

@Michalison 

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] > _DATE
    )

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.