Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a table which can be simply put as having a location and a rating (from 1-5) as column titles with entries of these on each row, as a measure the default would be the count of the rating of 1 - 5 but what I would like to be able to show is the average rating of each location rather than the average of the count of rating.
Any help would be great.
1.Create custom Columns for all rating by multiplying them by their base value - Rating1*1 = 1*Table1[Rating1]
2. Sum the score - TotalRating = Table1[Rating1*1]+Table1[Rating2*2]+Table1[Rating3*3]+Table1[Rating4*4]+Table1[Rating5*5]
3. Sum the no of responses - TotalResponses = Table1[Rating1]+Table1[Rating2]+Table1[Rating3]+Table1[Rating4]+Table1[Rating5]
4. Calculate the avg - Avg = Table1[TotalRating]/Table1[TotalResponses]
Or you can do all the above in a single step and have an Average column
Hi,
Is there a way to get the count of each rating into a new column as I mentioned that the ratings of each entry are in seperate rows.
Hi @andy88,
The values (5, 2) of "FinalSatisfaction" shown in above screenshot are the count value of rating, right? Then, how could I know the actual ratings of each location?
Please provide more sample data and show us your desired output with example to help us better understand your requirement. I need to know the structure of rating table, how to calculate the average value, what is your desired result.
Regards,
Yuliana Gu
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |