cancel
Showing results for 
Search instead for 
Did you mean: 

control how table total row is calculated per column

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!

 

Status: Delivered
Comments
Community Support Team

Hi @lgroger ,

 

 

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. 


Currently, this is not supported. You may need to submit a feature request at ideas page.

 

Best regards,

Yuliana Gu

Community Support Team
Status changed to: Delivered
 
Frequent Visitor

Sorry, @v-yulgu-msft , I thought this was the ideas portal since I clicked the "submit an idea" button to create it.  I'll resubmit it on the link you provided.