Help with DAX Formula -- 3

Job ID: 33354127

Budget: $10 – $30 AUD

Hi All,

I need a bit of help with 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. (image1)

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

I can provide a dummy pbix file.

Ideally what I am trying to achieve is to Count how many employees have worked more than 38 hours and less than 56 hours per week by location.
Related categories: Microsoft PowerBI