Calculate Sum of Sum of percentages

[Krcmajster]

I know the title is stupid but it's the only way I could explain it.

I have on table with percentages and product:

ID		Perc
1	p1	20%
1	p2	20%
2	p2	40%
3	p1	50%

And another with Amounts

ID
1	10,000
2	20,000
3	5,000

I need a measure (can't use calculated columns) to calculate percentages of amounts by each product and then sum them up.
So If I use slicer and select p1 i'll get 20 % of 10,000 and 50% of 5000, which would be 4500. If I select p2 I will have 20% of 10,000 and 40% of 20,000 so 2,000+8,000=10,000

[jdbuchanan71 · Accepted solution]

@Krcmajster 

Give this a try.  Assuming the tables are linked on the ID field.

Amount by PCT = 
SUMX('Table','Table'[Perc] * RELATED(Amounts[Amount]))