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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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.


Click here and Go to My LinkedIn Page


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.


Click here and Go to My LinkedIn Page


Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors