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.

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
Employee
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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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