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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
cdfisher89
Helper I
Helper I

Have row sum appear as a static column

I am trying to have the individual row values appear in one column and then the sum appear in the second column for each row. I can't get it to work. Any suggestions.  An example is below.

 

19 is the sum of all the values in the first column.

 

 
Individual Values      |     Total
3                               |     19
5                               |     19
7                               |     19
4                               |     19

1 ACCEPTED SOLUTION
danrmcallister
Resolver II
Resolver II

Forgive me, are you trying to have the second column show as 19 or as the sum for that row?  If the former, you'd use 

 

Total = CALCULATE(
    SUM(Table1[Values]),all(Table1[Values]) 
    )

Looks like this:

 

PBI Sum Ignore Filter.jpg

 

 

If you are looking for the latter, you can use a formula like:

 

Total = Table1[Values]

But if that's what you're looking for I suspect there's a deeper question that makes it more complicated Smiley Very Happy  Let me know if it helps.

 

 

View solution in original post

2 REPLIES 2
danrmcallister
Resolver II
Resolver II

Forgive me, are you trying to have the second column show as 19 or as the sum for that row?  If the former, you'd use 

 

Total = CALCULATE(
    SUM(Table1[Values]),all(Table1[Values]) 
    )

Looks like this:

 

PBI Sum Ignore Filter.jpg

 

 

If you are looking for the latter, you can use a formula like:

 

Total = Table1[Values]

But if that's what you're looking for I suspect there's a deeper question that makes it more complicated Smiley Very Happy  Let me know if it helps.

 

 

Phil_Seamark
Microsoft Employee
Microsoft Employee

Try this.

 

Column = CALCULATE(sum('Table1'[Values]),ALL('Table1')) 

 

I've assumed your table is called Table1 and the column is called Values


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.