Keep group average while sliced by individual

[YBZ59]

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) as well and not have it changed upon slicing, How can I do that?

So when I slice I get the user average per item and the overall average of the item itself

These are the values on the visualization 

The grade is already set to average

[Jihwan_Kim]

Hi,

I do not have your sample dataset, so I tried to create a simple one.

I hope you can get an idea.

Please check the below picture and the attached pbix file.

Avg per group =

VAR newtable =

ADDCOLUMNS (

FILTER ( ALL ( Data ), Data[Group] = MAX ( Data[Group] ) ),

"@groupavg", [Avg per program:]

)

RETURN

IF ( HASONEVALUE ( Data[Group] ), AVERAGEX ( newtable, [@groupavg] ) )

[YBZ59]

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 · Accepted solution]

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.