How to show 2 values in one column

[Anonymous]

Hello all, I want to make a survey report. The requirement is fairly straightforward.

For each column, it has 5 possible answers(all are strings)

5

4

3

2

1

I just want to calculate the percentage of the sum of both 5 and 4 to the total responses(5+4+3+2+1) and plot it in a graph. I know how to plot all 5 in different bars in a bar diagram. But no idea how to combine just 2 of those 5. Please help

[Anonymous]

Hello @mangaus1111.

Sorry, If I was not clear. I don't want to count the values. For some surveys they keep the responses as 

"strongly agree, agree, neutral, disagree, and strongly disagree". So counting the values is not a sustainable solution.

5,4,3,2 and 1 are the rating given to a particular survey question. I just want to calculate the total number of people who responded with 5 or 4 rating and plot it against the total number of people who attended the survey.

After ploting all the 5 results is there any way to group just 2 of those bars in the bar diagram into one? That is also a viable solution

[mangaus1111]

hI @Anonymous ;

then your expected result is 50% in my below sample table?

[Anonymous]

@mangaus1111  Yes precisely. 

[mangaus1111 · Accepted solution]

Hi @Anonymous ,

you can use

Measure =

VAR _Count4_5 =

CALCULATE(

          COUNTROWS('Facts34'),

          'Facts34'[Column] IN {4,5}

        )

VAR _Count_All =

COUNTROWS('Facts34')

RETURN

DIVIDE(_Count4_5,_Count_All)

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@mangaus1111 , thank you. this sounds like a viable solution. But I got a doubt if you don't mind. The output value will be 0.5 right? How do I show it as 50% in the graph? I am not able to show it as percentage in the graph since I can't use measures in both x and y axis

[mangaus1111]

I don´t know which kind of graph you are using, but generally first you clik on the measure and then you change the format as percentage.

[Anonymous]

Thank you for the answer. I think that solves my issue. 🙂

[mangaus1111]

Hi @Anonymous ,

do you need a measure like this or something different?