Multiple question survey

[enavesca]

I have been trying to figure out this simple problem, but I have had no success with that. Any help would be appreciated.

I have a survey with multiple questions (Q1, Q2, Q3, Q4, ...). For each question, the respondent can answer with Agree, Disagree, Strongly Agree, or Strongly Disagree. 

This is the Excel data

	Q1	Q2	Q3	Q4	Q5
Person 1	disagree	disagree	agree	agree	agree
Person 2	stronglyAgree	agree	stronglyAgree	stronglyAgree	stronglyAgree
Person 3	stronglyDisagree	disagree	agree	stronglyAgree	disagree
Person 4	agree	agree	stronglyAgree	stronglyAgree	stronglyAgree
Person 5	agree	agree	agree	agree	agree
Person 6	stronglyAgree	agree	agree	agree	agree
Person 7	agree	disagree	agree	stronglyAgree	agree
Person 8	agree	disagree	disagree	agree	agree

I need to calculate the percentage of each answer for each question and present the result below:

	Q1	Q2	Q3	Q4	Q5
agree	50%	50%	63%	50%	63%
stronglyAgree	25%	0%	25%	50%	25%
disagree	13%	50%	13%	0%	13%
stronglyDisagree	13%	0%	0%	0%	0%

------------------------------------------------------------------------------------

This is the data pivoted within Power Query (one column for question and another for answer)

I created the following measure, but it is not working...

percentage answer =

    DIVIDE(

        CALCULATE(

            COUNTROWS(TABLE),

            ALLEXCEPT(TABLE, TABLE[field])

        ),

        CALCULATE(

            COUNTROWS(TABLE),

            ALL(TABLE)

        )

    )

This is a very common survey, but unfortunately, I am stuck on the calculation. Has anyone had this issue before?

Thanks a lot!

[lbendlin · Accepted solution]

No need for any DAX.

[enavesca]

Worked!

Thanks 🙂