Count for every day from startdate and enddate

Hi bdeleur 
Please refer to attached sample file with the solution

Count = 
VAR CurrentDate = SELECTEDVALUE ( 'Date'[Date] )
VAR CurrentHour = SELECTEDVALUE ( Hours[Hour] )
RETURN
    SUMX ( 
        VALUES ( 'Table'[department] ),
        VAR CurrentDepartmentTable = CALCULATETABLE ( 'Table' )
        VAR FilteredTable = 
            FILTER ( 
                CurrentDepartmentTable, 
                VAR StartDate = 'Table'[start date]
                VAR EndDate = 'Table'[end date]
                RETURN
                    CurrentHour 
                        IN SELECTCOLUMNS ( 
                            GENERATESERIES ( MAX ( CurrentDate, StartDate ), MIN ( CurrentDate + 0.99, EndDate ), 1/24 ), 
                            "@Hour", HOUR ( [Value] ) 
                        )
            )
        RETURN 
            COUNTROWS ( FilteredTable )
    )

Max Count = 
MAXX ( 
    CROSSJOIN ( 
        VALUES ( 'Date'[Date] ), 
        VALUES ( Hours[Hour] ) 
    ),
    [Count]
)

Min Count = 
MINX ( 
    CROSSJOIN ( 
        VALUES ( 'Date'[Date] ), 
        VALUES ( Hours[Hour] ) 
    ),
    [Count]
)

Average Count = 
AVERAGEX ( 
    CROSSJOIN ( 
        VALUES ( 'Date'[Date] ), 
        VALUES ( Hours[Hour] ) 
    ),
    [Count]
)