Hello guys,
I have this problem. I would like to calculate the bundle price and this is my model.
Sales table:
Product name Price
| Main Device A | 10000 |
| Component 1 | 500 |
| Component 2 | 600 |
| Main Device B | 15000 |
| Component 3 | 1000 |
| ... | |
and I have another table with Bundles which has Many to Many relationship with the table above on Product name = Product name
Parts Product name Bundle Name
| Part 1 | Main Device A | Bundle A |
| Part 2 | Component 1 | Bundle A |
| Part 3 | Component 2 | Bundle A |
| Part 1 | Main Device B | Bundle B |
| Part 2 | Component 1 | Bundle B |
| Part 3 | Component 1 | Bundle B |
| Part 4 | Component 3 | Bundle B |
What I want to achieve is to have a Price per Bundle Name. For example Bundle A price is the sum of each components: (Main Device A, Component 1, Component 2) 10000 + 500 + 600 = 11100
for Bundle B it is (Main Device B, Component 1 x2, Component 3) 15000 + 500 + 500 + 1000 = 17 000
I am a bit lost on what should be a DAX code for the price?
