Forum Discussion
Create a score frequency table & assign value to text
Hello, I want to make a score frequency table of a questionnaire result in PowerBI. Something like the table below. My data set in PowerBI looks like this: 1. How do I make P...
amitchandak
Super User
Super UserLee478 , First unpivot questions in power query
https://radacad.com/pivot-and-unpivot-with-power-bi
Also, use find and replace to convert text Strongly agree to numbers
Then you need a measure = countrows(Table)
bucket = Generateseries(1,100,1)
the you need measure like
new Measure
Countx(filter(Summarize(Table[Question], Table[Rating]), [Measure] = max(bucket[Value])), [User])
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
Hello amitchandak
Thank you for your answer.
I'm a beginner of PowerBI. I just realised this was more challenging than I thought. Do you mind explaining why the step/solution is used and what result will I get for each step? (just a brief explanation will do)