Calculate FTE based on hours works

[Dtstraten]

Hi, 

I have run into an issue where I can't get the right values when I try to calculate it on an overall basis. The norm time that we are going with is 40 hours per week. So if you have worked 40 hours that equals one FTE. If you have worked 60 hours that's 1.5 FTE.  
The fields above is what I have to work with. 
* Hours = Sum(hours)

* Count weeks = distintcount('Hours*[Date (bins)])

* Calculated FTE = ([Hours]/40)/[Count weeks]

The issue with this one is that it calculates correctly on an individual basis but if you look at it from a cororate basis as someone starting at the middle of the year shouldn't count as one. This is evident when looking at projects etc where maybe there only has been work 3 weeks out of 52 weeks. Then the calculation needs to be on the 52 weeks an not only the 3 weeks. 

So I added another calculation in order to try to resolve this:

* Max weeks = CALCULATE([Count weeks], ALLEXCEPT('Hours', 'Hours'[Date].[Year]))

This gives me the 52 weeks as I want but when I go into the months it will always use the 52 weeks. So obviously this is not correct either. So I can't just multiply it by 52 as the full year then will be totally wrong. 

I really hope that there is an easy way of doing this that I just haven't considered. PLEASE HELP! 

Thanks Danny 

[Ashish_Mathur]

Hi,

Show some data and the expected result.