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]))
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
5 years ago

tinstin 

Try it like this.

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