Count only specific rows

[jcastr02]

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

[v-cazheng-msft · Accepted solution]

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.

[amitchandak]

@jcastr02 , Try a measure like

countrows(filter(Table, Table[Status] ="Not Started"))