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

[Anonymous]

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.the categories are the ones with the percentage in red/green and the ones with percentage in black are the subcategories for the category above

[tamerj1]

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]

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

[tamerj1]

@Anonymous 

Apologies. This should be AVERAGE not sum

[Anonymous]

not working even with average

[Anonymous]

[tamerj1]

@Anonymous 
Can we connect via teams or zoom?

[Anonymous]

I'll see if it's possible