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 PowerBI count the frequency of each score, not the number of entries?
2. How do I assign a score to each text label so that PowerBI can count the score frequency? (Strongly agree=5, Agree=4, Netural=3, disagree=2, Strongly disagree=1)
Thanks!
2 Replies
- amitchandak
Super User
Lee478 , 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)
