Head count formula not working

Hi,

I wish to calcute number of contracts and FTE's. My employee data set looks like this:

Person ID                  Cost Center            Role                 Employment start date         Employment end date               Work degree             PersonCCRoleWD               PersonCCRole

I have a separate calendar table which I try to connect with the employee data thorugh formulas.

I started of by using the forumlas below because I only want to calculate the rows when people have actually changed role/cost center/work degree. (One employee can be counted multiple times in our system, and I only want to count them once with the help of this "code").

Correct Start date = CALCULATE(MIN('People Data'[Employment start date]);

ALLEXCEPT( 'People Data'; 'People Data'[Person CC Role WD]))

Correct end date = CALCULATE(MAX('People Data'[End date modified]);

ALLEXCEPT( 'People Data'; 'People Data'[Person CC Role WD]))

To count number of contracts, I used this formula:

Contracts =

CALCULATE (

DISTINCTCOUNT ('People Data'[Person CC Role]);

FILTER (

'People Data';

'People Data'[Correct Start date]<=MAX('Dynamic Calendar Table'[Date])

&& 'People Data'[Correct end date]>MAX( ('Dynamic Calendar Table'[Date])

)))

Some how I do not get the right number of contracts with the above formulas.

When i try to calculate FTE's I use this formula:

FTE =

CALCULATE(

SUMX (DISTINCT('People Data'[Person CC Role]);[Max Work degree alt])

;FILTER (

'People Data';

'People Data'[Correct Start date]<=MAX('Dynamic Calendar Table'[Date])

&& 'People Data'[Correct end date]>MAX( ('Dynamic Calendar Table'[Date] )

)))

Where Max work degree is based on:

Max Work degree alt = CALCULATE ( [Max Work Degree];

FILTER('People Data';

Max('People Data'[Employment start date])))

max work degree = calculate(max('People Data'[Work Degree]);allexcept('People Data';'People Data'[Person CC Role]))

 I hope this was somewhat clear.. Can anyone help me? MY PBI file is depening on the head count to be correct. Thanks in advance!

Kinds regards