Count Number of Employees who has worked more than 38 and less than 56 hours per week

[Rubal_Islam]

Hi All,

I need a bit of help witht the below formula.
I am trying to count number of employess who has worked more than 38 hours and less than 56 hours per week.
I also have a date table where i have a week number column and connected with employee table with the date column.

Measure = CALCULATE(

DISTINCTCOUNT(Master_data[Employee Num]),

FILTER(Master_data,Master_data[Hours Worked]>38 && Master_data[Hours Worked]<56))

This is the base table. week number for the month of March 22 for a selected location. 

However as soon as i bring the measure in, it becomes blank

Any help is appreciated.

Thank you.

[VijayP · Accepted solution]

@Rubal_Islam 

you need to follow segmentation

use this file and let me know whether this helps you!

Please share your Kudos

[Rubal_Islam]

I will check it out. Thanks Vijay, Much Appreciated.

[Tutu_in_YYC]

Hi Rubal_Islam,
If it blanks, it means that there is no employee that satisfy that filter context:

- Are you sure you have employees working with that hours in that weeks?

- Is [Hours Worked] a measure or a column? and is it the right data type?

[Rubal_Islam]

Hi There,

I have changed the formula to show  greater than 38 and lower than 56. it is still blank for 1 given week.

You can see on the right table that there are individual employees who has worked more than 38 hours that week.

I think my formula is not taking it to the individual employee level, rather doing it as a whole?

[Tutu_in_YYC]

Could it be the weekNumber column is not accurate? Because in a year, there is a max of 52 weeks. Weeknumber 91 doesnt make sense, but maybe im missing a context here. 21st March should be week no 12.

If you have a pbix, I can have a look.

[Rubal_Islam]

@Tutu_in_YYC @  weeknumber had it sum instead of don't summarize. that is not the issue here.

[Tutu_in_YYC]

The measure looks right. The issue must be something else, eg a relationship/visual configuration