Total due hours for each person, each one with date in and date out, and on a specific range of days

[pedroccamara]

My model has 3 fact tables and for that reason all of them are connected with dates through an inactive connection.

I want to get this information from 5 jan till 12 Jan. The problem is that my measure sum correctly the Due hours for each person but doesn't sum. The detail numbers are correct.

I' ve created a measure :

DueWorkTime = SUM ( 'Tab Dates'[DueWorkTime] ) allows me to sum all weekdays from my calendar table

Second measure:

DateMin =
CALCULATE (
MAX ( 'Tab TimeSheet'[Date] ),
FILTER (
'Tab TimeSheet',
'Tab TimeSheet'[id_user] = RELATED ( 'Tab Employee'[id_user] )
))

There's also a DateMax. My point is to get the due time for each employee according to their dates in and out.

Now, i can do the main measure of Due Hours for each employee

T Hr Due =
CALCULATE (
[DueWorkTime],
DATESBETWEEN ( 'Tab Dates'[Date], [DateMin], [DateMax]),
VALUES( 'Tab Dates' )
)

And, as you all can see, the totals for this measure aren't good. They show me only the due time for the filter date (from 5 till 12) which means 7 days, times 8 hours each day, 56 hours.

Can anybody help me here? OR is there any other, better way to solve this?

Thanks a lot all of you

Pedro