How to create rank from rank scale questionnaire

[aizamkamadin]

i would like to create rank as per below image.
done i excel..but dont know how to do it in power BI.

Thank in advance..

Here is the sequence to get the rank
1. from the result table - get the frequency of each rank

2. then transpose it to new table

3. calculate the total for each indicator with this formula

Total = Rank1*6+rank2*5+rank3*4+rank4*3+rank5*2+rank6*1
4. finally, rank the row based on the highest no.

[aizamkamadin]

problem solved..but if you have a solution..pls share

[v-xulin-mstf]

Hi @aizamkamadin,

Congratulations, if the issue has been solved, please adopt your solution to help others.

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[amitchandak]

@aizamkamadin , You have to create Rank and then you have to create a new table using generate series and then create new measure to display using rank

rank table = addcolumns(generateseries(1,10,1), "Rank1", "Rank " & [value])

refer video, you need = join not between

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k