over due count

[naftycs]

Hello:

Great minds. Could you please help me to create a measure that calculates in progress overdue as of Today?

I need the total count of Overdue , where Overall Status = "Complete" and "In progress" "(BLANKS) AND PWC Actual Completion Date is Filter only BLANK AND PWC Schedule Completion Date everything before today.  Appreciate your help. 

Thanks

[naftycs]

Sorry, I could not understand. 

[Anonymous · Accepted solution]

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.

[Ashish_Mathur]

Hi,

Show the expected result very clearly.