Forum Discussion
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) 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
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.
3 Replies
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:])RETURNIF ( HASONEVALUE ( Data[Group] ), AVERAGEX ( newtable, [@groupavg] ) )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.
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.
