Lookupvalue combined with switch function

Hi,

I created 2 dummy tables to explain my question. I would like to have a slicer with values from 'Table1'[Subscriptiontype] (Values are Yearly and Monthly)

Output of measure should be the sum of all prices related to the products

Table1

Table2

I used a LOOKUPVALUE expression but ofcourse that will give an error that multiple values are found because I have all products both on a yearly and monthly expression.

Would be grateful for the solution:)

Kind Regards,

Soof1234