Eric Vogelpohl on 06 Feb 2015 06:22:56
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”.
- Comments (2)
RE: In Table Object - Ability to Not Total Numeric Column
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.
RE: In Table Object - Ability to Not Total Numeric Column
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)