cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

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.

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.

2 REPLIES 2
Super User

Hi, @laurent_rio

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.

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.

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors