Count column text value filtered by two other columns

[Anonymous]

Hi there.

I have a 'Task' table where I need to count the number of times the text "Not completed" appears in the 'Task progress' column.

The count needs to be limited by the text values of the other table columns 'Critical Task' and 'Overdue' both being "True".

I have tried with COUNTAX() and FILTER, but I never seem to get the correct result.

Any ideas on how to count the number of not completed tasks that are also critical and overdue?

[vanessafvg · Accepted solution]

what does your statemetn look like?

test =
CALCULATE (
    COUNTROWS ( table ),
    FILTER (
        table,
        table[taskprogress] = "Not Completed"
            && table[CriticalTask] = "True"
            && table[Overdue] = "True"
    )
)

[Anonymous]

Your solution works perfectly!

Can you explain the difference between using the FILTER function and just adding the filters at the end as part of the CALCULATE  function?

Like Calculate (expression, filter 1, filter 2, filter 3)

[vanessafvg]

@Anonymous not quite sure what you asking but this should be informative

https://www.sqlbi.com/articles/filter-arguments-in-calculate/