Sum of Averages issue.

[Anonymous]

Hi Dear experts,

I tied creating this following visual in Power BI, indicating the formulae i used to derive other attributes, but when i tired to roll up what what get in Power Bi default is "Red highlighted" numbers where, I wanted to Achive the aggregation as in "Green"

Appriciate your help,

Thank you,
Chandra

[MattAllington · Accepted solution]

Read my article here https://exceleratorbi.com.au/use-sum-vs-sumx/

you should read it all, but look for the section toward the bottom called "totals don't add Same principle applies for average vs averagex

[Anonymous]

Thank you Matt, great explaination ..!