Forum Discussion
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 t...
Hi,
Does this work
M_Count of Sprints = COUNTROWS(Filter('tasks',Containsstring([Task Name],"sprint")&&[Task Percent]=100))
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.
You are welcome.