Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Power BI - Matrix Chart not showing the right total based on filter selection

Hello Community,

I encounter an issue where I have a matrix chart with category and subcategory and for example if I have a slicer for wether category or subcategory and I select something the total is gonna show the one for every subcategory/category.
Posting some snapshots of my matrix chart and the measure I use for it.image.pngimage.pngthe categories are the ones with the percentage in red/green and the ones with percentage in black are the subcategories for the category abovethe categories are the ones with the percentage in red/green and the ones with percentage in black are the subcategories for the category above

7 REPLIES 7
tamerj1
Super User
Super User

hi @Anonymous 

whay not just using SUM of the [Result] column? Why do you need a calculated column for each type of aggregation? This is supposed to happen automatically inside the matrix!

Anonymous
Not applicable

DavidVasilis_0-1676019900239.png

this is what is happening when I do that, basically because I need a sum for subcategory and an avg for a category and a total

@Anonymous 

Apologies. This should be AVERAGE not sum

Anonymous
Not applicable

not working even with average

Anonymous
Not applicable

image.png

@Anonymous 
Can we connect via teams or zoom?

Anonymous
Not applicable

I'll see if it's possible 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.