Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Fabric Data Days Monthly is back. Join us on March 26th for two expert-led sessions on 1) Getting Started with Fabric IQ and 2) Mapping & Spacial Analytics in Fabric. Register now

p_lamonica

Matrix/Table grand totals with Measures

Submitted by on ‎07-16-2018 08:59 AM
It would be great if Grand Totals on a Matrix or Table would add up correctly to the sum of the rows when you include MEASURES in the visual. Currently the total on a measure consists of the measure function itself, instead of the sum of the rows above. PLEASE give us the option to toggle totals to be a simple aggregate of the rows above also.
Status: Under Review
See more ideas labeled with:
158 Comments (158 New)
Comments
fbcideas_migusr
New Member
‎02-24-2025 05:25 PM
Status changed to: Under Review
 
TheHank
Regular Visitor
‎03-17-2025 08:55 AM
What are you waiting for?
alexherrera421
New Member
‎05-20-2025 06:04 AM
how long must i wait........ :/...:(...:'(
straumanny
New Member
‎08-22-2025 01:32 AM
10 years of PBI, why something so basic is not a priority for Microsoft?
GConey
Regular Visitor
‎10-17-2025 04:36 AM

7 years later and this is still an issue while Microsoft is busy showing Copilot down people's throats while not being able to deliver the most basic of functionalities.

Antero
New Member
‎12-16-2025 11:15 PM
How many more years we need to wait?
AFoisAnalytics
Frequent Visitor
‎12-19-2025 08:41 AM
In Tableau i can do this in a second, simply choosing on Visual Level in the option for the table Total how the aggregation got to work. Here in Power BI i have to wright instead stupid complicated DAX. PS: I can not imagine how reports there are around the world returning wrong results because the users and developers don't know that Totals in tables and matrix in Power BI are BROKEN! Please fix it.