Submissions needed

Hi All

Someone provided assistance to me with calculating submissions. In essence my organisation requires individuals to submit a report every single week so we track actual submissions over required submissions. This KPI is monitored against both the individual and the manager they report to. 

In essence:

-An individual is expected to submit 10 reports but only submitted 5

-A manager has 3 individuals reporting to him/her and is therefore expected to have 30 submissions.

What needs to be taken into account is when the person is hired and leaves as submissions cant be required before their joining and after they leave so in the individual mastersheet we have the following columns a name, manager of the person, joining date and exit date.

The DAX I have at the moment is as follows:

Required Submissions =

VAR _First=FIRSTDATE('Calender'[Week End Date])

VAR _Last=LASTDATE(Calender'[Week End Date])

VAR _EFirst=MIN(Mastercode[Hiring Date])

VAR _ELast=MIN(Mastercode[Exit Date])

VAR _Start=MAX(_First,_EFirst)

VAR _End=IF(ISBLANK(_ELast),_Last,MIN(_Last,_ELast))

VAR _Check= _Start&"|"&_End&"|"&DATEDIFF(_Start,_End,WEEK)+1

VAR Result = MAX(0,DATEDIFF(_Start,_End,WEEK)+1)

Return

SUMX(

VALUES(Mastercode[Individual Name]),

CALCULATE(Result)

The issue arising at the moment is if we are tracking managers required submissions and they have one individual that has left it assumes all individuals have. I know this has to be an issue where iteration is required I am just not sure how to tackle it.

Really appreciate the assistance everyone!