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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
laurent_rio
Helper I
Helper I

Calculate Total Resign/Active Employee per quarter

Hi,

I get the employee list report by end of quarter, for example Q4 2020 = date of report 31/12/2020. This is my list 

Capture.JPG

 

How to Calculate The Total of resign people in Q4 2020/Active People in Q2020 

 

The answer should be = 3/10

My idea is try to make condition DAX to count 

 

Calculate (Sum(Total resign), Filter(Termination date.(quarter) = Report date.(quarter) & termination date.(year) = Report date year)))

But again i cant figure out to get the correct DAX 

Can anyone help ?

Thanks

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi, @laurent_rio 

I am not sure about how your data model looks like.

Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.

I created it without DIM Calendar Table.

 

Picture13.png

 

Resign People in Q4 =
CALCULATE (
COUNTROWS ( VALUES ( Employee[Employee] ) ),
FILTER (
Employee,
QUARTER ( Employee[Resign Date] ) = QUARTER ( Employee[Date] )
)
)
 
 
Active People in Q4 =
CALCULATE (
COUNTROWS ( VALUES ( Employee[Employee] ) ),
FILTER (
Employee,
Employee[Status] = "Active"
)
)
 
 
 

Hi, My name is Jihwan Kim.


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


Linkedin: https://www.linkedin.com/in/jihwankim1975/

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Visit my LinkedIn page by clicking here.


Schedule a meeting with me to discuss further by clicking here.

View solution in original post

2 REPLIES 2
Jihwan_Kim
Super User
Super User

Hi, @laurent_rio 

I am not sure about how your data model looks like.

Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.

I created it without DIM Calendar Table.

 

Picture13.png

 

Resign People in Q4 =
CALCULATE (
COUNTROWS ( VALUES ( Employee[Employee] ) ),
FILTER (
Employee,
QUARTER ( Employee[Resign Date] ) = QUARTER ( Employee[Date] )
)
)
 
 
Active People in Q4 =
CALCULATE (
COUNTROWS ( VALUES ( Employee[Employee] ) ),
FILTER (
Employee,
Employee[Status] = "Active"
)
)
 
 
 

Hi, My name is Jihwan Kim.


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


Linkedin: https://www.linkedin.com/in/jihwankim1975/

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Visit my LinkedIn page by clicking here.


Schedule a meeting with me to discuss further by clicking here.

amitchandak
Super User
Super User

@laurent_rio ,Refer if my blog can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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

Top Solution Authors