Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
littlepatos
Helper II
Helper II

Count occurrences of specific values in a column

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.

littlepatos_0-1674272605475.png

littlepatos_1-1674272650598.png

 

 

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

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" ) )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


View solution in original post

2 REPLIES 2
Jihwan_Kim
Super User
Super User

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" ) )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


This worked perfect- thanks for the quick response.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.