Calculate average omitting slicer selection

[boehnc]

Fairly new to PP, so I might be overthinking this. If I create a dashboard with Student, Class, and Semester slicers, and I select Student (Bobby), Class (History), what PP calculation function would I use to create a pivot table that will create an average (this I know), and Average of all students (this I don't know)...but subtracting Bobby's grade.

I'd like to compare the average grade of whatever student/Class slicer selected against the rest of the students/class if they were taken out of the equation.

So If I have Bobby slicer selected as well as History, how do I get a pivot with the following fields and averages? Thanks for any direction.

History grade average
Bobby: 78
Rest of Students: 85 (just Tom and Sally)..


Student Class Grade Semester
Bobby History 78 Fall
Bobby Economics 82 Fall
Tom History 75 Spring
Sally History 95 Spring
Sally Economics 75 Fall
Susan Economics 85 Winter

 

[Ozeroth]

You're wanting to create a measure which inverts the Student slicer selection.

Have a look at this post/thread for a couple of ways of doing it.
http://www.mrexcel.com/forum/power-bi/858206-excluding-row-item-group-calcuation.html#post4171354

If you might select more than one student on the slicer, then you want to use the method using CONTAINS.