Forum Discussion
AVG instead Total in matrix
I need to show the avg in table view instead of the Sum. Is any way I can show avg there.
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
2 Replies
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:
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
