Matrix sub total is not adding up properly

[Anonymous]

subtotal is not adding up properly, I'm not using measure it is simple matix, would anyone please help, thanks

[Greg_Deckler]

@Anonymous - 

If this is a not a measure, then it looks like you are using Average aggregation, so it is going to average at the subtotal level as well. If you want it to be one thing at one level (aggregation type) and a different aggregation at a different level, you need: MM3TR&R: https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-...

If this is a measure then this looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

[amitchandak]

@Anonymous , this is % so should not add up.

Make sure you formula should be like 

measure = divide(sum(Table[Value]), sum(Table[Value2]))

if you want some or change the way avg work

sumx(summarize(Table, Table[Project],"_1",[Measure]),[_1])

[Anonymous]

how do I share a data sample? csv, excel, zip, and html are returning errors

[Anonymous]

@Anonymous 

Just select the data in excel copy and paste it here.

s'd	sdf
sdf	sdf

Regards
Paul

[FrankAT]

Hi @Anonymous 

please, can you provide some sample data and what you want to achieve.

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)