Forum Discussion

naftycs's avatar
naftycs
Regular Visitor
4 years ago
Solved

over due count

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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

     

naftycs's avatar
naftycs
Regular Visitor
4 years ago

Sorry, I could not understand. 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.