I've created a function that tells me the number of workdays since a project has started excluding weekends, however I now want to filter it by the days where work was completed by an employee (so don't count a day as a workday if no work was done WHERE 'Production'<2)
I've created the following Measure:
Work Days on Project Before Today = COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR("1/1/2020",TODAY()),"Day of Week",WEEKDAY([DATE],1)),[Day of Week]<>1 && [Day of Week]<>7))
This returns the number of work days since the project was started, however some employees take vacation so the number of workdays
varies from employee to employee how do I return the number of workdays for each individual employee using a column named "production"
Where im determining if the employee has a production values of less than 2 then they were out for the day and I wouldn't want it counted towards their number of workdays
Side Note: I created an additional measure
Was Employee in = IF(COUNT('employee'[production])>2,1,0)
However when i added it to a matrix table along with employees and dates the rows don't add up across to give me a total of the number of days worked, it returns the value 1 instead of a row total
