Forum Discussion
Helper ISurvey Analysis: Count and Add the response
jambopriti Review the following screenshot and measure. Hope it works.
COunt Answers = COUNT('Table'[answer])/CALCULATE(COUNT('Table'[answer]),All('Table'))
Top2ResponsesPercentage =
VAR TopNTable =
TOPN(
2,
ALL('Table'[answer]),
[COunt Answers],
DESC
)
RETURN
SUMX(
TopNTable,
[COunt Answers]
)Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!Review the pbix file attached,
Top2ResponsesPercentage =
VAR TopNTable =
TOPN(
2,
ALL('Table'[answer]),
[COunt Answers %],
DESC
)
RETURN
SUMX(
TopNTable,
[COunt Answers %]
)Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!Perfect! It is working! Thank you so much for your solution and support!
Helper IHi, Here is the data. Thank you!
Respondent_id,question,answer
5751,How satisfied are you with the web site experience?,Very Satisfied
5752,How satisfied are you with the web site experience?,Satisfied
5753,How satisfied are you with the web site experience?,Very Satisfied
5760,How satisfied are you with the web site experience?,Very Satisfied
5761,How satisfied are you with the web site experience?,Satisfied
5762,How satisfied are you with the web site experience?,Very Satisfied
5763,How satisfied are you with the web site experience?,Neutral
5764,How satisfied are you with the web site experience?,Very Satisfied
5767,How satisfied are you with the web site experience?,Very Satisfied
5769,How satisfied are you with the web site experience?,Satisfied
5770,How satisfied are you with the web site experience?,Very Satisfied
5772,How satisfied are you with the web site experience?,Satisfied
5775,How satisfied are you with the web site experience?,Very Satisfied
5776,How satisfied are you with the web site experience?,Satisfied
5778,How satisfied are you with the web site experience?,Very Satisfied
5779,How satisfied are you with the web site experience?,Very Satisfied
5780,How satisfied are you with the web site experience?,Very Satisfied
5781,How satisfied are you with the web site experience?,Satisfied
5783,How satisfied are you with the web site experience?,Very Satisfied
5785,How satisfied are you with the web site experience?,Satisfied
5787,How satisfied are you with the web site experience?,Neutral
5788,How satisfied are you with the web site experience?,Very Satisfied
5789,How satisfied are you with the web site experience?,Neutral
5790,How satisfied are you with the web site experience?,Very Satisfied
5791,How satisfied are you with the web site experience?,Very Satisfied
5792,How satisfied are you with the web site experience?,Neutral
5793,How satisfied are you with the web site experience?,Satisfied
5795,How satisfied are you with the web site experience?,Very Satisfied
5796,How satisfied are you with the web site experience?,Satisfied
5797,How satisfied are you with the web site experience?,Satisfied
5799,How satisfied are you with the web site experience?,Satisfied
5800,How satisfied are you with the web site experience?,Very Satisfied
5801,How satisfied are you with the web site experience?,Dissatisfied
5802,How satisfied are you with the web site experience?,Dissatisfied
5803,How satisfied are you with the web site experience?,Dissatisfied
5804,How satisfied are you with the web site experience?,Very Dissatisfied
5805,How satisfied are you with the web site experience?,Very Dissatisfied
5806,How satisfied are you with the web site experience?,Very Dissatisfied
5807,How satisfied are you with the web site experience?,Very Dissatisfied
Solution SupplierReview the pbix file attached,
Top2ResponsesPercentage =
VAR TopNTable =
TOPN(
2,
ALL('Table'[answer]),
[COunt Answers %],
DESC
)
RETURN
SUMX(
TopNTable,
[COunt Answers %]
)
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
- jambopriti
Perfect! It is working! Thank you so much for your solution and support!