Average of Sub Totals

[dphillips]

Here is a table showing Students, BOSUnits and a sub total for each student which is the sum of BOSUnits. I would like to get the average of each of the subtotals. (In the example shown it would be (10+11+11+11 + etc / n) Also - this is only for 2017. I would also like to be able to compare the average Number of Units done by a student across a number of years.

Not sure how to do this in DAX and would love some help.

[v-ljerr-msft · Accepted solution]

Hi @dphillips,

If I understand you correctly, you should be able to use AVERAGEX and SUMMARIZE function(DAX) to create a measure to calculate the average in your scenario. However, without knowing your real table structures, it's hard to write the measure for. So the formula below is for your reference. 

Measure =
AVERAGEX (
    SUMMARIZE ( 'Table1', 'Table1'[Students], "adc", SUM ( 'Table1'[BOSUnits] ) ),
    [abc]
)

Regards

[dphillips]

Thanks - exactly what I was after!