Forum Discussion

YBZ59's avatar
YBZ59
Regular Visitor
4 years ago
Solved

Keep group average while sliced by individual

Hi,   I'm trying to get average by row on a matrix, when I slice by a selected user I get his average (Grade) per P item (row) which is fine,  but I want to add the group average (overallaverage) a...
Show and Tell
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Hi YBZ59 ,

     

    Try to create a measure like below:

    Measure = CALCULATE(AVERAGE('Table'[Grade]),ALLEXCEPT('Table','Table'[Course Name]))

     


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

YBZ59's avatar
YBZ59
Regular Visitor
4 years ago

Thanks, but this doesn't seem to work

My data is very simple, I have the course titles and grades of students.

I want to create a matrix with 3 columns, 'Course name', 'grade', and 'average course grade, so when I slice by student name I can get his grade on the course under the 'grade' column and the average course grade under the 'average course grade' column. I am able to get only the grade of the student when I slice and when I remove the slice of course the average of the course is shown (which is ok).

Thank You.

V-lianl-msft's avatar
V-lianl-msft
Community Support
4 years ago

Hi YBZ59 ,

 

Try to create a measure like below:

Measure = CALCULATE(AVERAGE('Table'[Grade]),ALLEXCEPT('Table','Table'[Course Name]))

 


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