Forum Discussion
Calculation help - average score per category
Hi there,
I am using a PowerBI report to display the results from a survey. The survey questions are grouped into themes, and the participants are grouped into cohorts.
For each theme, I want to be able to display the average score per question, for each cohort. That is, if you refer to the model below, I want question_number on the x-axis, calculated_average* on the y-axis (the value I'm trying to figure out), and the cohort shown in the legend (so that the average values are split per question in the graph).
Basically, I want it to look exactly like the following graph, but to display the average value for each question rather than the sum of scores.
Thank you in advance for your help!!
Hi amied
you can change the aggregate in the visual as shown in the screenshot below.
Let me know, if this is what you are looking for.
Thanks and Regards,
Praful
3 Replies
Hi amied
you can change the aggregate in the visual as shown in the screenshot below.
Let me know, if this is what you are looking for.
Thanks and Regards,
Praful
Oh my goodness, of course! Thank you, I was way over-complicating it. Appreciate your help.
Hi amied
You can use implicit measures by changing the aggregation type of a column as Praful_Potphode has suggested. A better practice though it to create explicit measures. You can do an average by using AVERAGE ( 'table'[numeric column] )
