Decompose Bundles into SKU'S

[aquanr18]

Hi, thanks alot for reading my post! 

As the subject describes I want to decompose some transactional data; my tables are

1) Transactional Data

Transaction Table

What I want is to be able to see how many real SKU's I'm selling. 

2) The BundlesTables; which tell's me what SKU are in the bundles and how the quantity

Bundle Table

3) Result Table, Via DAX or the query editor I want to be able to get this table

Result Tablle

Any Help will be much appreciated!

[v-chuncz-msft · Accepted solution]

@aquanr18,

You may add a calculated table first.

Table =
GENERATEALL (
    'Transaction',
    SELECTCOLUMNS (
        FILTER ( Bundle, Bundle[Bundle] = 'Transaction'[Product] ),
        "P2", Bundle[Product],
        "Q2", Bundle[Quantity]
    )
)