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 progress" "(BLANKS) AND PWC Actual Completion Date is Filter only BLANK AND PWC Schedule Completion Date everything before today.  Appreciate your help. 

Thanks

 

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.

     

3 Replies

    • 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.