Custom column; show aggregate total on each row based on values in a column

[lpriceFTW]

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

[Greg_Deckler]

@lpriceFTW Excel to DAX Translation - Microsoft Power BI Community Look at the S category for SUMIF equivalent.

[RemyO · Accepted solution]

Think your answer is here

https://community.powerbi.com/t5/Desktop/Sum-of-values-by-each-category/m-p/134279

[lpriceFTW]

Thanks this worked.