How to show Late task, Overdue task & ontrack task count in Power BI with Visuals

Hi amaoa ,

You may create measure like DAX below.

Overdue Task =
CALCULATE (
    SUMX (
        Table1,
        IF (
            MAX ( [Finish Date] ) < TODAY ()
                && MAX ( [% Comp] ) <> 100
                && ( MAX ( [Finish Date] ) <> BLANK () ),
            1,
            0
        )
    )
)

If I misunderstood it, you may clarify which situation will be marked as "Overdue Task" , "Ontrack Task" and  "Late task" based on your data table. See the similar case: Counts in a period of time.

Best Regards,

Amy 

Community Support Team _ Amy

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