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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
asta
Regular Visitor

How do i calculate sum of three rows for each rows with different values

How do i calculate sum of three rows for each rows for exampple TableA(ColumnA+ColumnB+Column C) in New Calculated Column D i want to show the sum like given below? Please help!

 

I am getting the same values for all the rows? I want the result as Column D which is total of col a, b and c.

 

A  B  C      D
1  1  0       2 ( Sum of A+B+C as 1+1+0)
0  1  0       1
1  1  1       3

1 ACCEPTED SOLUTION
v-haibl-msft
Microsoft Employee
Microsoft Employee

@asta

 

Just try like below.

Column D =
TableA[A] + TableA[B] + TableA[C]

How do i calculate sum of three rows for each rows with different values_1.jpg

 

Best Regards,

Herbert

View solution in original post

5 REPLIES 5
v-haibl-msft
Microsoft Employee
Microsoft Employee

@asta

 

Just try like below.

Column D =
TableA[A] + TableA[B] + TableA[C]

How do i calculate sum of three rows for each rows with different values_1.jpg

 

Best Regards,

Herbert

Yeah that was pretty easy like this..it did work !

@asta

 

If you have got your problem solved, you could mark the right answer as solution to close this thread. Smiley Happy

 

Best Regards,

Herbert

Vvelarde
Community Champion
Community Champion

hi @asta

 

In a Calculated Column:

 

SumABC = CALCULATE(SUMX(Tabla1,Tabla1[A]+Tabla1[B]+Tabla1[C]))




Lima - Peru
CheenuSing
Community Champion
Community Champion

Hi @asta

 

Try the folliwng using sumx to iterate over each row.

 

ColumnD=sumx(Yourtable, (cola+colb+colc))

 

If this works please accept this as solution and also give KUDOS.

 

Cheers

 

CheenuSing

 

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors