MDX – Sum values by keys across tables

I currently have two tables in my database, which can be simplified as follows:

GoodsStatus               GoodsPrice ID|status                 ID|price ---------                 -------- 1 |     2                 1 |    5 2 |     1       and       2 |    8 3 |     4                 3 |   12 4 |     1                 4 |    7 5 |     3                 5 |    1 

What I want to do now is to have a calculated member in SSAS to present the sum up value of the prices for goods only with a status of 1, i.e. when I run through the query I should expect a value of 8+7=15.

I have a feeling that could involve somehow finding IDs in one table with condition from the other, but I’m very new to SSAS and MDX and have since lost here.