Weighted averages rolled up two levels

[damiendry]

 Howdy All,

Looking to roll up weighted averages across multiple levels. First to a group level, then to a class level. The below table gives a brief dataset overview.

I'm struggling to roll up the average weight sum for the class level (in green), the Group level appears to work alright but struggling for the class level.

Any feedback would be appreciated.

Warm Regards

[Ashish_Mathur]

Hi,

Share the download link of the PBI file and also explain how to calculate the average at the Class level.

[v-shex-msft · Accepted solution]

Hi @damiendry,

According to your description, it seems like a common multiple aggregations requirement.

You can create a variable with SUMMARIZE function to do the first level aggregate and use iterator function SUMX to apply the second level on previous calculation results.

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng