Forum Discussion

AJV's avatar
AJV
Icon for Helper I rankHelper I
6 years ago

Survey Analysis - Top/Bottom Scoring Questions

Hello:   I am looking for some suggestions as to how to produce a table that shows the analysis of survey data.   Of a survey containing 50-60 survey questions, we need to draft a table that show...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

AJV , for this your question and score both need to be in rows.  The based on average Score and Rank you can find top and bottom 3

Score = average(Table[question Score])

 

High Rank = RANKX(all(Table[Question]),[Score])

Low Rank = RANKX(all(Table[Question]),[Score],,asc, dense)

 

Top 3 = CALCULATE([Sales],TOPN(3,all(Table[Question]),[Score ],DESC),VALUES(Table[Question]))

bottom 3 = CALCULATE([Sales],TOPN(3,all(Table[Question]),[Score ],ASC),VALUES(Table[Question]))