over due count

Hi naftycs ,

I think you can try this code to create a measure to calcualte the total count of Overdue.

Total Count of Overdue = 
CALCULATE (
    DISTINCTCOUNT ( 'Table'[ID] ),
    FILTER (
        'Table',
        'Table'[Overall Status]
            IN { "Completed", "In-Progress", "" }
                && ISBLANK ( 'Table'[Deloitte Actual Completion Date] )
                && 'Table'[Deloitte Schaduled Completion Date] < TODAY ()
    )
)

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.