Forum Discussion

Clint's avatar
Clint
Helper V
7 years ago
Solved

Counting rows based on multiple values

Hello,

 

I need to count rows in a table that meet two criteria:

- Task percent complete equals 100

- Task name contains the word "sprint"

 

I have the following measures that counts the rows that contain the word sprint but I don't know how to add the second criteria for  task complete=100.   Any insight is greatly appreciated.

M_Count of Sprints = COUNTROWS(

Filter('tasks',

Containsstring([Task Name],"sprint")

))

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    Does this work

    M_Count of Sprints = COUNTROWS(Filter('tasks',Containsstring([Task Name],"sprint")&&[Task Percent]=100))

3 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

    Does this work

    M_Count of Sprints = COUNTROWS(Filter('tasks',Containsstring([Task Name],"sprint")&&[Task Percent]=100))

    • Clint's avatar
      Clint
      Helper V
      7 years ago

      Hello Ashish_Mathur ,

       

      Yes, with a slight modification, it does.

      M_Count of Sprints complete =
      COUNTROWS(Filter('tasks',Containsstring([Task Name],"sprint")&&[Task Percent Completed]="100"))
       
      I had to put the task percent completed value in quotes to get it to evaluate.  Otherwise BI complained about comparing integers and text.  The values returned seem to be correct however.  Thank you for showing me how to combine both into one filter.