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 IThank you. one more question.
my card display 0.88, How do I convert into percentage? sorry this is so dumbquestion but I'm totally new to Power BI and learning.
Solution Supplierjambopriti Click on % Sign,
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
- jambopriti
Thank you so much!!!
It is working. I'll mark this as a solution! Truly appreciate your help!