cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## 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

1 ACCEPTED SOLUTION
Community Support

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 3
Super User

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 =
FILTER ( ALL ( Data ), Data[Group] = MAX ( Data[Group] ) ),
"@groupavg", [Avg per program:]
)
RETURN
IF ( HASONEVALUE ( Data[Group] ), AVERAGEX ( newtable, [@groupavg] ) )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Visit my LinkedIn page by clicking here.

Schedule a meeting with me to discuss further by clicking here.

Regular Visitor

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.

Community Support

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors