Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

In Table Object - Ability to Not Total Numeric Column

In the Table object, if you drag a measure like “SUM(Product Weight) or “MAX(Temperature)" to display as an attribute of the row, it totals or displays it on the bottom of the table. (Sum measures total, max measures just repeat the max) It doesn’t always make sense to display the aggregate total on the bottom if the table is at the level of grain-record. Having the ability to toggle off the total would be nice so you don’t have to create a calculated column for the same thing. E.g. click the drop down in the field list and choose “do not show total”.
Status: Needs Votes
Comments
Kim1
New Member
indeed, it would be nice if you have the choice tot show totals or not. for exemple in finance reports where there is already a total (account shedule, MS NAV)
larry_clark
New Member
It's crazy that this isn't already a feature. I've heard this negative feedback twice now in the past three months on consulting gigs, and the typical question is "how can I present this visual to an executive when you're summing the exchange rate column on the Total row?" I know there's a HASONEFILTER DAX workaround, but that's a huge amount of work for a large data set.
fbcideas_migusr
New Member
Status changed to: Needs Votes