Forum Discussion
Helper IICustom column; show aggregate total on each row based on values in a column
I have a table containing invoice data. Invoices are broken down by item/item amount.
I want to create a column in this table that shows the invoice total based on the invoice number of the calculated row.
I created the below table in Excel using a sumif formula which looks at the range of the invoice column, criteria equals the column/row being evaluated, and the sum range is the amt column.
How do I do this in PowerBI?
Example table (see desired results in pink):
| ID | Invoice | Item | Amt | Inv Total |
| 1 | 1001 | A widget | 0.50 | 4.50 |
| 2 | 1001 | B widget | 0.50 | 4.50 |
| 3 | 1001 | C widget | 1.00 | 4.50 |
| 4 | 1001 | D widget | 1.00 | 4.50 |
| 5 | 1001 | E widget | 1.50 | 4.50 |
| 6 | 2001 | A widget | 0.50 | 1.00 |
| 7 | 2001 | B widget | 0.50 | 1.00 |
| 8 | 3001 | A widget | 0.50 | 2.00 |
| 9 | 3001 | B widget | 0.50 | 2.00 |
| 10 | 3001 | C widget | 1.00 | 2.00 |
Think your answer is here
https://community.powerbi.com/t5/Desktop/Sum-of-values-by-each-category/m-p/134279
3 Replies
RemyOResolver I
Think your answer is here
https://community.powerbi.com/t5/Desktop/Sum-of-values-by-each-category/m-p/134279
- lpriceFTW
Thanks this worked.
- Greg_Deckler
Community Champion
lpriceFTW Excel to DAX Translation - Microsoft Power BI Community Look at the S category for SUMIF equivalent.
