Measures to Count Projects Completed on Time and Late

[SAHoff]

I'm working with a list of completed and ongoing projects and trying to report on the numbers ofcompleted projects that were:

1. completed before or on their due dates; and
2. completed after their due dates (late).

Here's what is not working:

Measure 1: 

CompletedLateCount = CALCULATE ( COUNT('WIP Tracker'[Title]), FILTER ( 'WIP Tracker', 'WIP Tracker'[Completion Date]>'WIP Tracker'[Due Date].[Date]) && ISBLANK('WIP Tracker'[Due Date]=FALSE()))

Measure2:

CompletedOnTimeCount = CALCULATE(COUNT('WFPP WIP Tracker'[Title])-[CompletedLateCount])

I'm new at this. Could someone help me out with the DAX here?

[Anonymous · Accepted solution]

Hi @SAHoff ,

Please try:

CompletedLateCount = 
CALCULATE (
    COUNT ( 'WIP Tracker'[Title] ),
    'WIP Tracker'[Completion Date] > 'WIP Tracker'[Due Date]
        && 'WIP Tracker'[Due Date] <> BLANK ()
)

CompletedOnTimeCount = CALCULATE(COUNT('WIP Tracker'[Title]),'WIP Tracker'[Completion Date]<='WIP Tracker'[Due Date])

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[SAHoff]

This is perfect. Thanks so much!

[djurecicK2]

Hi @SAHoff ,

 You can achieve this by using a calculated column like below. Please adjust to fit your table and field names.

Status = IF('WIP Tracker'[Due Date]>'WIP Tracker'[Completion Date],"On-Time","Late")

After this column has been created, create a measure to count status= On-Time and a measure to count status= late.

Please consider marking as solution if this has answered the question.