cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Changing totals on tables

Guys is there any easy way to make the column totals a sum rather than an average in the table below :

 

Table.PNG

11 REPLIES 11

New Mesuare = SUMX( VALUES(family id[family id]), [price per item]))

 

excuse me forget to close the parentheses

View solution in original post

Thank you very much for your help that has solved it 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors