Forum Discussion
Matrix sub total is not adding up properly
subtotal is not adding up properly, I'm not using measure it is simple matix, would anyone please help, thanks
5 Replies
- FrankATCommunity Champion
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) - AnonymousNot applicable
how do I share a data sample? csv, excel, zip, and html are returning errors
- AnonymousNot applicable
Anonymous
Just select the data in excel copy and paste it here.s'd sdf sdf sdf
Regards
Paul
- amitchandakSuper User
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])
- Greg_DecklerCommunity Champion
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-Roll/m-p/411443#M150
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