Calculate discounted rate where it match name from other table

[Anonymous]

Hi All, 

I have two tables the relationship in the column 'Type' . I want to Sum 'Price A' and 'Price B' then multiply by the value that matchs the type name from Table1. 

I tried this " =sumx( table1, table1[Price A] + table1[price B] * related( 1+ Table2[Discount]))), but it returened wrong discounted value. 

Is there any other way ? 

Table1:

Type	Price A	Price B
A	115	60
B	84	40
C	11	50
D	51	88
D	22	65
E	221	70
E	66	88
E	66	15
A	66	12
A	66	22

Table2 :

Type	Discount
A	-0.05
B	-0.04
C	0.9
D	0.7
E	0.8

Thank you in advance!

[Zubair_Muhammad]

@Anonymous

Do you want new column in Table1?

Try Something like this

Column =
 ( table1[Price A] + table1[price B] )
    * ( 1 + RELATED ( Table2[Discount] ) )

[Anonymous]

 It doesn't work. I want the sum value from table1 - percnet from table2 , but only when type match. For example; Type "A" should calcuate the sum of Price A and Price B then multiply by the Type A from Table2 which is -.05. I should get 166.25. 

Thank you, 

[Zubair_Muhammad · Accepted solution]

@Anonymous

I get 166.25 as well