Combined Matrix

Hi Marico ,

The following virtual table can be created with the help of the NATURALINNERJOIN function:

FlagTable = 
SUMMARIZE(
    'SalesData',
    'SalesData'[Category],
    'SalesData'[Flag],
    'SalesData'[Internal/ External],
    "SalesAmount", SUM('SalesData'[Sales])
)

TotalSalesTable = 
SUMMARIZE(
    'SalesData',
    'SalesData'[Category],
    'SalesData'[Internal/ External],
    "TotalSales", SUM('SalesData'[Sales])
)

FinalOutputTable = 
NATURALINNERJOIN(
    SUMMARIZE(
        'SalesData',
        'SalesData'[Category],
        'SalesData'[Internal/ External],
        "TotalSales", SUM('SalesData'[Sales])
    ),
    SUMMARIZE(
        'SalesData',
        'SalesData'[Category],
        'SalesData'[Flag],
        'SalesData'[Internal/ External],
        "FlagSales", SUM('SalesData'[Sales])
    )
)

Best Regards,
Adamk Kong

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