Dear All please help me to finalize some dutie in Power BI. I'm actualy working to create a dashboard for analizing leave day. The issue I'm facing is I cann't count only colleagues are filed their timesheet for leave and let other colleagues who have not done it. NB: I have created a date Table for sciling each month and show colleague are left or plan to leave. Below my code witch count also the reste of colleagues.If your leave extends over two months, each month is counted

Number of Staff on leave = 
COUNTROWS(
    FILTER(
        DISTINCT('Annual Leave'[First  Name] ),
        CALCULATE(
            NOT ISEMPTY( 'Dates'),
            KEEPFILTERS(
                CALCULATETABLE(
                    DATESBETWEEN(DATES[Date], MAX( 'Annual Leave'[Leave Start Time] ), MAX( 'Annual Leave'[Leave End Time] ) )
                )
            )
        )
    )
)