Forum Discussion
Higher grain Summarization
Dear DAX community, I want to understand the difference between AVERAGE and AVERAGEX in terms of working method and capacity. The formula for the average is SUM(amount)/Number of Instance. AVER...
Greg_Deckler
Community Champion
Community Championdhamodarankms So AVERAGE accepts a column as an input. AVERAGEX accepts a table or table expression as an input as well as a column specification. So, you can do this:
AVERAGE('Table'[Column]) will give you the average of everything in the table in that column
with AVERAGEX you can do things like:
AVERAGEX(FILTER('Table',[Device] = "A"),[Column])
This allows you to create some kind of filter and then just do an average over that subset of the table and column values.