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 Average score of each Department of each row. Let's say Name A,  Avg. Depart score must be 24 and so on in each row.

I tried with
CALCULATE (AVERAGEX(TABLE,TABLE[Score]), FILTER(TABLE, TABLE(Department))

but it's not work. Woud you please help?
Need Help
Tutorial Requests

2 Replies

  • 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]))
  • 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.