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.

Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

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'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.