cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Highlighted
Super User
Super User

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)
1 REPLY 1
Highlighted
Super User
Super User

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)

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 38 members 1,041 guests
Please welcome our newest community members: