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

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.

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
v-yulgu-msft
Employee

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

v-yulgu-msft
Employee
Status changed to: Delivered
 
lgroger
Advocate I

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.