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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
GD61
Helper III
Helper III

SUM row by row

Hi, 

In my table, I want to add a new column to display the sum row by row :

Crime rate + Community well-being + Cost of living + Health care quality + Tax rate

What is the formula to do that?

Thanks for help

Sum row by row.jpg

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

If I understand correctly, you would create a custom column with the formula:

 

MySum = [Crime rate] + [Community well-being] + [Cost of living] + [Health car quality] + [Tax rate]

 

You could also create a measure with the same formula and place it in a table visualization.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
Greg_Deckler
Super User
Super User

If I understand correctly, you would create a custom column with the formula:

 

MySum = [Crime rate] + [Community well-being] + [Cost of living] + [Health car quality] + [Tax rate]

 

You could also create a measure with the same formula and place it in a table visualization.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

hello sir, i have the same issue and i did what u mentioned but the column shows total sum and not the individual sum...i even tried dont summerize option but its not working.. pls help @Greg_Deckler 

i want to use this calc and then also divide this number by the number of columns i used.. to get the average   ex: i have 12 columns and sometimes a row may only have 6 columns that have a number "1" so if the sum is 6 and i want to average it throught the 12 columns. i want the average to return ".5 " not averaging it through only the 6 filled columns returning "1".  

@Greg_Deckler

Thanks! That works!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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