cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Calculate Table and add row as a sum of values

Hi there,

I am relatively new, therefor a more basic question. But i just can't figure the solution.

 

I would like to calculated a table including a sum of one of the columns. The calculated row is summing up the values based on a certain characteristica. (I don't want to create a matrix visual)

 

The table are invoices with references to orders. I need to know the sum of order value

Original Table

Invoice NumberOrder NumberInvoice Value
1O1210
2O1312
3O1210
4O1510

 

Desired Output Table

Order NumberSum Invoice Value
O1220
O1312
O1510

 

Please help. Much appreciated.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User IV
Super User IV

@beatbrun use a  table visual,

 

add order number and Invoice Value and it will give you the sum of invoice value assuming it is a number field.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Highlighted
Super User I
Super User I

Hi @beatbrun ,
Try this

 

myTableToo = SUMMARIZECOLUMNS('Table'[Order Number],"Sum Invoice Number",SUMX('Table','Table'[Invoice Value]))

 

new.PNG

 

Go to the Modeling tab, select New Table and add code.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

4 REPLIES 4
Highlighted
Super User IV
Super User IV

@beatbrun use a  table visual,

 

add order number and Invoice Value and it will give you the sum of invoice value assuming it is a number field.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Highlighted
Super User I
Super User I

Hi @beatbrun ,
Try this

 

myTableToo = SUMMARIZECOLUMNS('Table'[Order Number],"Sum Invoice Number",SUMX('Table','Table'[Invoice Value]))

 

new.PNG

 

Go to the Modeling tab, select New Table and add code.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted

PERFECT! This is it! You made my day! 😄 @Nathaniel_C 

Highlighted

Hi @beatbrun ,
Glad I could help!
Nathaniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors