DAX Utilization Measure by employee

[ShortyAO]

Hello,

I was able to get the utilization by Employee to work based on the following DAX I found in the link below.  However, I am not able to understand why on some employees that worked a full month do not populated the expected hours available for the month.  For example, an employee Started 6/2 but in May is reflecting 8 hours available when should be zero.  On another employee who worked the full month of May only shows 168 hours available when it should be 176.  What could be causing this?

http://stackoverflow.com/questions/31420864/dax-utilization-measure-formula

[hours available]:=SUMX(resources,CALCULATE(SUM(calendar[utility_hours]),FILTER('calendar',calendar[date_key]>=FIRSTDATE(resources[hire_date_key])),FILTER('calendar',calendar[date_key]<=LASTDATE(resources[termination_date_key]))))

[v-luwang-msft]

Hi @ShortyAO ,

Is it possible to share your model data, when I click on the model data in your connection he jumps to another page (and there is no data), remember to delete confidential data.

Best Regards

Lucien

[ShortyAO]

Hello,

Unfortunetly, I don't have the option to load the file.