Forum Discussion

amied's avatar
amied
Frequent Visitor
1 year ago
Solved

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...
Need Help
  • Praful_Potphode's avatar
    Praful_Potphode
    1 year ago

    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

danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

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] )