How to Get the Maximum Condition-Based Logging of All Data

I have attached the test PBIX file as mentioned below.

Link to test PBIX file: https://1drv.ms/u/s!AiSRcgO5FUmN8w4UpKd5wMPcvPuI?e=rnLWaF

Test data:

In the test data above,

1) If I select the time "11:00 AM",

First, we need to filter each employee's unique time in the "DOJ" column maximum

Second, after filtering the maximum time, the "EmpStatus" filter is just OK.

If "EmpStatus" is Reject, that employee does not need to be considered.

Therefore, the final total of the records for "11:00 AM" is (1 record. (i.e.) Waugh ==> 10:45 AM). the other record of James's Empstatus is Reject. so there's no need to consider Jame's track record. This is until 11:00 a.m. of registration.

2) If I select the time "03:00 PM",

First, we need a unique filter for each employee in the maximum time of the "DOJ" column

Second, after filtering the maximum time, the "EmpStatus" filter is just OK.

Therefore, the final total of the records for "03:00 PM" is (1 record. (i.e.) again James' record should come ==> 02:42 AM). the other Waugh Empstatus record is Reject. so there's no need to consider Waugh's record. This is until 03:00 PM registration

In this way, we need to form the condition.

How to do this..?