cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mholsen Regular Visitor
Regular Visitor

Count column text value filtered by two other columns

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Count column text value filtered by two other columns

what does your statemetn look like?

 

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


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
3 REPLIES 3
Super User
Super User

Re: Count column text value filtered by two other columns

what does your statemetn look like?

 

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


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Mholsen Regular Visitor
Regular Visitor

Re: Count column text value filtered by two other columns

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)

Highlighted
Super User
Super User

Re: Count column text value filtered by two other columns

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

 

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


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!