Total of all transactions related to one item type

[jaliu1290]

Hello Power BI Community!!

I have a table of Items, Amounts, and associated Transaction IDs and would like a measure to calculate the Expected Outcome.

Item	Amount	Transaction	Expected Outcome (Total of All Transactions)
Square	5	ABC	60
Circle	10	ABC	35
Triangle	20	ABC	80
Square	5	DEF	60
Triangle	20	DEF	80
Triangle	20	HIJ	80

Transaction total for ABC = 35, DEF = 25, and HIJ = 20.

Therefore, if want to be able to slice by Square, then I want it to retrieve Transactions ABC and DEF that contained Square items, but then finally sum the entire total amount of those Transactions.

Thanks in advance,

Jamie

[ThxAlot]