Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
5 years ago
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 Jose...
Need Help
  • v-cazheng-msft's avatar
    v-cazheng-msft
    5 years ago

    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.

     

v-cazheng-msft's avatar
v-cazheng-msft
Community Support
5 years ago

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.