Sub totals Not working in Matrix Visual

[Anonymous]

Hi 

I have a matrix table like below

Total shows wrong.

[Anonymous · Accepted solution]

....aaaand you expect that the 61% is the AVERAGE of Feb 2020 column values?

So you want the average of a percentage?

IF SO then that's not the way powerbi works (and honestly I wouldn't calculate an average of a percentage as it won't be weighted). If that's your problem, look here:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

But first, have a look on how filters work in Powerbi

[Anonymous]

Well. How are we supposed to help you? It could be a data error, could be a Measure Total common issue, it could be wrong filters...it could be anything.

But in your case it looks like that you're shoinwg percentages. For example the 61% in Feb 2020: what do you expect, the AVERAGE of percentages? 

[amitchandak]

Can you share the formula, you are using.

[Anonymous]

I dont apply any filters.i have the dataset like place,month and sale percentage.

row headers is place

column headers is month

and the values are my sales pecentage

[Anonymous · Accepted solution]

....aaaand you expect that the 61% is the AVERAGE of Feb 2020 column values?

So you want the average of a percentage?

IF SO then that's not the way powerbi works (and honestly I wouldn't calculate an average of a percentage as it won't be weighted). If that's your problem, look here:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

But first, have a look on how filters work in Powerbi

[Anonymous]

Yes.  creating total measure is possible??????..means'' total monthwise sales divided by count ''

[Anonymous · Accepted solution]

So you want to make an average of percentages. Cool, have a look at the link I provided.

[Anonymous]

I tried.. i couldnt create the exact measure.anyways thanks for the help