Forum Discussion

Dominok123's avatar
Dominok123
Frequent Visitor
7 years ago
Solved

Finding Average, Sum and CountDistinct after Grouping

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: Colum...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Dominok123 

    Try to use this measure definition

    AvgSales = CALCULATE(AVERAGE(Table1[Sales]),ALLEXCEPT(Table1,Table1[Group]))
     
    Regards
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dominok123 

Try to use this measure definition

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