Forum Discussion

tinstin's avatar
tinstin
Regular Visitor
5 years ago
Solved

Average Score Column by Departmet

                I have table like the picture above, I have no problem to get the average score of this data set  AVERAGEX(TABLE,TABLE[Score]) Now I'd like to get a Ave...
Need Help
Tutorial Requests
  • jdbuchanan71's avatar
    jdbuchanan71
    5 years ago

    tinstin 

    Try it like this.

    CALCULATE(AVERAGE('Table'[Score]),ALLEXCEPT('Table','Table'[Department]))
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi tinstin 

Group by department and then count the average.

Create a measure like this :

Measure = CALCULATE(AVERAGE('Table'[Score]),ALLEXCEPT('Table','Table'[Department]))

And the result is as shown :

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.