Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
subtotal is not adding up properly, I'm not using measure it is simple matix, would anyone please help, thanks
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
@khussein , 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])
how do I share a data sample? csv, excel, zip, and html are returning errors
Hi @khussein
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |