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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Create a row in the table with the sum

Hello, 

 

I want to do a table, that have a sum of a colunm in the table. For Example:

 

I have this table:

Code Total
1 10
2 20
3 30
4 40
5 50

 

And i try to create a row that have a sum of Total Colunm:

 

Code Total
1 10
2 20
3 30
4 40
5 50
1+2+3+4+5 150

 

This is possible to do in DAX or in a power Query?

 

Thanks a lot

1 ACCEPTED SOLUTION

@Anonymous 

Actually it was like this before I edit it after having a 2nd read. Please use

NewTable =
UNION ( Table1, { ( "Total", SUM ( Table[Total] ) ) } )

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

@tamerj1 

 

Thank you very much!!

tamerj1
Super User
Super User

Hi @Anonymous 
With DAX you can create a new calculated table 

 

NewTable =
UNION ( Table1, { ( SUM ( Table[Code] ), SUM ( Table[Total] ) ) } )

 

 

If you have multiple coulmns in the original table then it needs some changes. 

Anonymous
Not applicable

Hi, @tamerj1 

 

I have a question, if instead of Sum the "Code" column, I wanted to put the name "Total Code". In the code changes " SUM ( Table[Code] )" for what?

 

For Example: 

 

Code Total
1 10
2 20
3 30
4 40
5 50
Total Code 150

 

Do you can help me?

 

Thanks a lot.

@Anonymous 

Actually it was like this before I edit it after having a 2nd read. Please use

NewTable =
UNION ( Table1, { ( "Total", SUM ( Table[Total] ) ) } )

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.