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

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

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
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.

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.

Go to My LinkedIn Page

2 REPLIES 2
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.

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.

Go to My LinkedIn Page

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

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

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors