Calculated Measure from two tables

Hi michaelshparber ,

Two workarounds:

1. Create a calculated table.

Table = 
VAR Sales1 =
    FILTER ( Sales, Sales[Bundle Sale Ind] <> "Bundle" )
VAR Sales2 =
    SUMMARIZE (
        Sales1,
        Sales[Transaction#],
        Sales[Product Group],
        Sales[Product],
        Sales[Amount]
    )
VAR Bundle1 =
    SUMMARIZE (
        'Bundle Details',
        'Bundle Details'[Transaction#],
        'Bundle Details'[Product Group],
        'Bundle Details'[Product],
        'Bundle Details'[Amount]
    )
VAR Sales3 =
    UNION ( Sales2, Bundle1 )
RETURN
    Sales3

Then, you can create a Matrix visual like so:

2. Or you can create a Product table first and then create a measure like so:

Product = SUMMARIZE ( Sales, Sales[Product Group], Sales[Product] )

Measure = 
VAR Sales1 =
    FILTER ( Sales, Sales[Bundle Sale Ind] <> "Bundle" )
VAR Sales2 =
    SUMMARIZE (
        Sales1,
        Sales[Transaction#],
        Sales[Product Group],
        Sales[Product],
        Sales[Amount]
    )
VAR Bundle1 =
    SUMMARIZE (
        'Bundle Details',
        'Bundle Details'[Transaction#],
        'Bundle Details'[Product Group],
        'Bundle Details'[Product],
        'Bundle Details'[Amount]
    )
VAR Sales3 =
    UNION ( Sales2, Bundle1 )
RETURN
    SUMX (
        FILTER (
            Sales3,
            [Product Group] = SELECTEDVALUE ( 'Product'[Product Group] )
                && [Product] = SELECTEDVALUE ( 'Product'[Product] )
        ),
        [Amount]
    )

BTW, .pbix file attached.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.