Combining Answers for Percentage

[DLB13]

Hi there - 

I have a set of questions with a likert scale (strongly disagree to strongly agree). I'd like to display this in power bi as "xx% of respondents agreed that....", with the % being the combination of respondents who answered "agree" and "strongly agree." I'm coming up short on how to do this - any tips? Many thanks!

[DLB13]

Bumping as I still have this question. I have to do this for a LOT of variables, so I'm hoping for a solution other than typing out a measure for each of them!

[v-diye-msft]

Hi @DLB13 

Not quite understand what you're looking for. You might consider providing your dummy pbix.

You can upload it to the onedrive for business and share the link here. please don't forget to disclose the expected results and remove the confidential info.

If you'd like to combine columns, you might check:

https://support.microsoft.com/en-us/office/merge-columns-power-query-80ec9e1e-1eb6-4048-b500-d5d42d9... 

[DLB13]

Here is a very simple data set.

Basically, in power BI, I want to be able to display "xx% of respondents agree", with the percentage calculating (number of "strongly agree" + number of "agree")/number of total respondents. 

Respondent	Question 1
1	Agree
2	Strongly Agree
3	Disagree
4	Neutral
5	Neutral
6	Agree
7	Agree
8	Strongly Agree
9	Strongly Disagree
10	Agree
11	Agree
12	Strongly Agree
13	DIsagree
14	Neutral
15	Disagree
16	Agree
17	Agree
18	Neutral
19	Strongly Agree
20	Disagree
21	Strongly Disagree
22	Neutral
23	Agree
24	Agree
25	Strongly Agree
26	Neutral
27	Disagree

[DLB13]

Just bumping this... hoping someone can help!

[amitchandak]

@DLB13 ,

Can you share sample data and sample output in table format?

[DLB13]

Hi there -

Thanks for reaching out so fast! Unfortunately I can't share the data, but the format is really simple. Respondents in column A, likert choice selection in column b (so one of five options: strongly disagree, disagree, neutral, agree, strongly agree). Does this help?

[Anonymous]

have u found a solution yet? Im having the same scenario too