Displaying count of overdue task

[DCS2011]

I have a bunch of task that have columns with a completion due date and date closed (among others).

How do I display the number of over due items, but not count the closed items in the process.

Current Method simplfied:

Calc(Sheet(ID), filter(completion<today)filter, sheet(date closed))

I get a number, just not the right number. 

[Anonymous]

Hi @DCS2011 ,

You can use the following DAX formula to display the number of overdue items, but not count the closed items in the process:

Overdue Items =
CALCULATE (
    COUNTROWS ( Sheet ),
    FILTER (
        Sheet,
        Sheet[completion due date] < TODAY ()
            && Sheet[date closed] = BLANK ()
    )
)

This formula counts the number of rows in the Sheet table where the completion due date is less than today's date and the date closed is blank. This will give you the number of overdue items that are not closed.

Note that the formula assumes that the completion due date and date closed columns are in the Sheet table. You may need to adjust the formula to match the names of your columns.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

[DCS2011 · Accepted solution]

I did not try this method, I used the first filter (<TODAY) and then created a second filter with date closed as well and that seems to be working. 

Aslo did the same thing for due in 7/30 days., but used TODAY()+7, etc.