Count records based on most recent record

Hello,

my model has a tablet which tracks different attributes of an employee, such as, designation, employment status, department, region, effective date.

the table doesn't have a relationship with date dimension.

Can you please suggest if I can create a DAX measure which only filters for the latest record based on employeeid's effective date and displays counts against any dimension like, region, status, department I select?

thanks