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

[Jay2077]

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?

[Zubair_Muhammad · Accepted solution]

@Jay2077

Quite Similar to your formula

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

OR

Measure2=countX(Filter(sheet1,Sheet1[Answer]="agree completely"),1)