Forum Discussion
Solved
Count only specific rows
Looking for a measure to countrows that ONLY has status task Status as "Not Started"
| Status | Name | Date |
| Not Started | Joe Smith | 1/1/21 |
| Not Started | Ann Taylor | 2/2/21 |
| Completed | Joseph Johnson | 3/3/21 |
| Not Started | Ariana Jackson | 4/4/21 |
Hi, jcastr02
You can also try a Measure like the following.
StatusNotStarted = COUNTX(FILTER('Table','Table'[Status]="Not Started"),'Table'[Status])The result looks like this:
Best Regards
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
jcastr02 , Try a measure like
countrows(filter(Table, Table[Status] ="Not Started"))
Hi, jcastr02
You can also try a Measure like the following.
StatusNotStarted = COUNTX(FILTER('Table','Table'[Status]="Not Started"),'Table'[Status])The result looks like this:
Best Regards
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
