Count occurrences of specific values in a column

[littlepatos]

I am trying to show comparison rates for completion of task where completion data is in a column with 2 value: Completed or Outstanding.  I think i need to create a measure which allows me to count how many are Completed & how many are Outstanding?? I would like to add a Card visual to show Total Outstanding.  I've tried googling but not sure what I'm asking.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, but please try something like below in case you want to create a card visualization.

Outstanding count measure: =
COUNTROWS ( FILTER ( Requests, Requests[Completed] = "Outstanding" ) )

[littlepatos]

This worked perfect- thanks for the quick response.