Finding the Sum of Some and All Rows - Power Query

[sorozco]

Hello all,
I am using Power BI to visually display survey scores, and the survey has different sections/categories.
For example, we'll say the survey has 20 questions, and questions 1-5 are category "A", 6-10 are category "B", 11-15 are "C", and 16-20 are "D". In my report, I'd like to display not only the average score across all categories and questions, but I’d also like to specify average scores within individual categories and the questions within them. But, I am having trouble adding row totals, but all rows and specific rows. Survey responses are being pulled directly from MSFT Forms.
I appreciate your help!

[Greg_Deckler · Accepted solution]

@sorozco You'll have to do a Group By operation like:

Table.Group(#"Changed Type", {"ID"}, {{"Total", each List.Sum([X]), type nullable number}})

That said, generally those kinds of calculations are better done in DAX.