Matrix filter on weekly basis

Hi,

I have a timesheet report for our team members which is made of a matrix breaking down into weeks and then a list of team members and their hours worked in that week.

The problem is some of our team members will leave the workplace but our HR has already auto populated public holiday leave in their timesheet. So the matrix shows every employee each week, including those who have left the company.

I have made a column in my timesheet entry table called "WasCurrentTeamMemberInWeek" in which I check if the week is greater than employee's leave date. If I add this to my matrix the employee list will be broken down into two list, those who are in the company and those who have left. 

Is there anyway to show only the current team members for each week, without having to add the additional measure to matrix? If I add the filter to visual or page level, it filters the False values on all weeks, including the weeks that a team member was actually still employed.

In other words I only want to see the team members who have worked and were still employed in any given week.