AVG instead Total in matrix

[Anonymous]

I need to show the avg in table view instead of the Sum. Is any way I can show avg there. 

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

[Price] should be calculated as a measure. Then, create an other measure to get the final result:

Averge of Price =
AVERAGEX ( TableName, [Price] )

Best regards,

Yuliana Gu

[Greg_Deckler]

Yes, take a look at this:

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also this:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-...