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.
I'd like to have better control over how the total row calculates each column in a table. For examples, sometimes I might want the value to be "Don't Summarize" for each row but I want the "Total" row to have the sum of all values. Right now, if set to "Don't Summarize", it doesn't show any total. Similarly, I'd like to be able to set how I want a measure aggregated in the "Total" column. Right now, it seems to use the same functions used in the measure for the total calculation which isn't always what I want. Here's an example use-case: https://community.powerbi.com/t5/Desktop/Change-the-way-total-of-column-is-displayed/m-p/718776 Someone gave me a complicated way to achieve what I want but it seems like it should be so much simpler than this!
UPDATE: I didn't realize this was the wrong forum for ideas. If you find this post and have a similar need, please vote for the idea here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33553138-customize-totals Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.