Finding Average, Sum and CountDistinct after Grouping

Question

Hey guys, super basic question but what would the DAX expression be for finding the average, sum and countdistinct of one column after being grouped by another column.&nbsp;Example for average:Column 1&nbsp; &nbsp; Column 2&nbsp; &nbsp; &nbsp;AverageGroup 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8Group 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8Group 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5Group 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5Group 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5Group 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15Group 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15

anonymous · Accepted Answer

Dominok123&nbsp;Try to use this measure definitionAvgSales = CALCULATE(AVERAGE(Table1[Sales]),ALLEXCEPT(Table1,Table1[Group]))&nbsp;Regards

Forum Discussion

Finding Average, Sum and CountDistinct after Grouping

2 Replies

Related content

Fabric & Azure Data User Group Program Requirements & Benefits

Grouped Average

average by group

Average by group

Community User Group Experience