Forum Discussion
Solved
Survey Analysis: Count and Add the response
Hi, I'm new to Power BI and need help in Survey analysis. I need to add count of top 2 responses. Would you please show how to do it? I have attached the test file. I'm trying to get this result....
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!
jambopriti Click on % Sign,
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Thank you so much!!!
It is working. I'll mark this as a solution! Truly appreciate your help!