Finding Average, Sum and CountDistinct after Grouping

[Dominok123]

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.

Example for average:

Column 1    Column 2     Average
Group 1           6                   8
Group 1          10                  8
Group 2           4                   5
Group 2           6                   5
Group 2           5                   5

Group 3           10                15

Group 3           20                15

[Anonymous · Accepted solution]

@Dominok123 

Try to use this measure definition

AvgSales = CALCULATE(AVERAGE(Table1[Sales]),ALLEXCEPT(Table1,Table1[Group]))

Regards

[Greg_Deckler]

The easiest way would be to put Column1 in a Table visualization. Then add Column2. In the Values area of the VISUALIZATIONS pane, use the little drop down arrow next to Column 2 to change the aggregation to average, etc.