Counting rows based on multiple values

[Clint]

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")

))

[Ashish_Mathur · Accepted solution]

Hi,

Does this work

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

[Clint]

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.

[Ashish_Mathur]

You are welcome.