cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Jay2077 Regular Visitor
Regular Visitor

Calculatng a measure for total number of answers for a given question

Ok so I have various questions and i'd lik eto create a new measure which will give me a count of the number of answers 

 

eg, I like football 

 

answers = 

 

10 = agree completeley 

8 = somewahat agree 

 

and so on 

 

How would I do this please ?  Is it something along the lines of measure = countx(sheet1,Sheet1[Answer]="agree completely")  I can't seem to get this to work.  

 

Alternatively how could i go about making numerous pie charts to show the answers of 7 or 8 questions without uploading them as sepreate sheets?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

Re: Calculatng a measure for total number of answers for a given question

@Jay2077

 

Quite Similar to your formula

 

Measure=countrows(Filter(sheet1,Sheet1[Answer]="agree completely"))

 

OR

 

Measure2=countX(Filter(sheet1,Sheet1[Answer]="agree completely"),1)
Try my new Power BI game Cross the River

View solution in original post

1 REPLY 1
Super User III
Super User III

Re: Calculatng a measure for total number of answers for a given question

@Jay2077

 

Quite Similar to your formula

 

Measure=countrows(Filter(sheet1,Sheet1[Answer]="agree completely"))

 

OR

 

Measure2=countX(Filter(sheet1,Sheet1[Answer]="agree completely"),1)
Try my new Power BI game Cross the River

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors