Calculate proportion of most favourable answer

[WolfP]

I am newbie to Power BI and I have the results of a survey as follow:

ID	Q1	Q2	Q3
a	yes	yes	sometimes
b	no	yes	yes
c	yes	sometimes
d	yes	sometimes	yes
e	sometimes	no	sometimes
f	no		sometimes
g	no		yes
h	yes	sometimes
i	yes	yes	no
j		yes	sometimes

I need to calculate the proportion of the most favourable answer for each question:

column = # of yes / # total number of answers

column = 5 / 9

So far I manage to use COUNT() and FILTER() separately to group and count the variable together, but I can not figure out the syntax to do it in a single measure.

I would appreciate any help

[tamerj1 · Accepted solution]

Hi @WolfP 
Please refer to attached sample file with the proposed solution. Perhaps you want to see the numbers as well but not sure what exactly is the results that you're looking for.