0

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.

  • Can you define the grain of both tables? Do they both have one row per ID? – GregGalloway Dec 23 '19 at 2:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.