Calculate Net Working Days

Hi Experts,

I am trying to calculate net working days between two dates that I'am capturing from slicer but somehow i am not getting the expected output.

Objective: I want to capture dates from the slicer and return net working days between that date range + i want to calculate user capacity (i.e per day working hours of user) during that date range (E.g - If user selects 10 days period in slicer, I want to return 1. Net working Days + 2. Daily working hours x 10 days = 80 + 3. I require this to calculate if user has booked 80 hours during 10 days or not -if less then i will show them Insufficient hours and vice versa)

Table name: Timesheet (62)

Column Name: Date

Column Name: 'Timesheet (62)'[IsWorkingDay]

Slicer using the [Date] Column.

Measures used: (this is done to keep it dynamic in nature upon user's selection of the specific date range)

Start date of filter = Capturing Start date of the slicer in using FIRSTDATE function
End date of filter = Capturing End date of the slicer in using FIRSTDATE function

DAX: 

WorkingDays = CALCULATE(COUNTROWS('Timesheet (62)'),DATESBETWEEN('Timesheet (62)'[Date],[Start Date of filter],[End Date of filter]),'Timesheet (62)'[IsWorkingDay]="True")

 

Is it allowed to use measures in this formula, if so then it's not filtering the data. I get the total of 11713 i.e. the toal of all TRUE values from [IsWorkingDay] column. 

 

Image for reference

 

Appreciate your response on this.

 

Thanks in advance!

 

- Manoj Nikam