Calculating a total column from 2 tables

[princee]

Hi 

I am creating the below table from 2 data tables. They are linked via a 'Sales status' column and product column via 2 other tables with a list of sales staus, and products. . I cannot however create a total count of all sales by status. Can you advise why this

I want

                           Sales status 1                                        Sales status 2

Product 1          total count from source 1&2            total count from source 1&2

Product 2

Using the matrix feature i just get the figures seperated out.

Thanks

Emma

[v-chuncz-msft · Accepted solution]

@princee,

You may try using Append Queries (Table.Combine) in Query Editor or UNION Function (DAX) to create a new table.