Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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?

Need Help
  • vanessafvg's avatar
    vanessafvg
    8 years ago

    what does your statemetn look like?

     

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

3 Replies

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    8 years ago

    what does your statemetn look like?

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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)