cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HannahWL Visitor
Visitor

Visualising the count of 'yes' answers on a card

Hi everybody,

 

 

I am trying to visualise using a card visualisation the number of 'yes' occurrences pulled from a single column. This column has either yes or no entries. I would like to represent this as a simple card - with the count of 'yes' occurrences. Any help would be great. 

 

Thanks, 

Hannah 

1 ACCEPTED SOLUTION

Accepted Solutions
meet2aftab Frequent Visitor
Frequent Visitor

Re: Visualising the count of 'yes' answers on a card

Hi Hannah,

You can create a calculated measures with below expression that you can use in you Card

 

Count of YES=

CALCULATE(COUNTA('YourTable'[Column]), 'YourTable'[Column] IN { "Yes" })

 

Thanks,

Aftab

View solution in original post

1 REPLY 1
meet2aftab Frequent Visitor
Frequent Visitor

Re: Visualising the count of 'yes' answers on a card

Hi Hannah,

You can create a calculated measures with below expression that you can use in you Card

 

Count of YES=

CALCULATE(COUNTA('YourTable'[Column]), 'YourTable'[Column] IN { "Yes" })

 

Thanks,

Aftab

View solution in original post

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 369 members 3,384 guests
Please welcome our newest community members: