Calculate proportion of most favourable answer

WolfP — Mon, 15 May 2023 04:56:57 GMT

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

Re: Calculate proportion of most favourable answer

tamerj1 — Mon, 15 May 2023 07:03:31 GMT

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.

topic Re: Calculate proportion of most favourable answer in DAX Commands and Tips

Calculate proportion of most favourable answer

Re: Calculate proportion of most favourable answer