Help with DAX Formula -- 2
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.
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.