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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
cdfisher89
Frequent Visitor

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors