Get count as per status date column

nailed , Two if you dates approved and rejected has some space or zero size text. Clean those in power query to make sure date type is date.

Two ways to deal with these measures. Based on their on date

Approved = calculate(countrows(compile), userelationship('Date'[Date], compile[Approved Date]))
Rejected = calculate(countrows(filter(compile,isblank(compile[Approved Date]) )), userelationship('Date'[Date], compile[Rejected Date]))
Submission = calculate(countrows(compile), userelationship('Date'[Date], compile[Submission Date]))

// based on submission date , assuming that is default active join
Approved = calculate(countrows(filter(compile,[status]= "Approved"))
Rejected = calculate(countrows(filter(compile,[status]= "Rejected"))
Submission = calculate(countrows(filter(compile,[status]= "Submission"))

Not you can use common date (joined with target too) and employee to analyze target together