Calculating sum of two non related data sets

[anthlen]

Hi All,

I would like to calculate a sum of two data sets that are non related-  what is the best practice for this.  Should I do this in Dax or in SQL?  

The tables come from two different data sets- in one case a roster and then one case a recruiting system where they are candidates

How do i add both East up into one chart so that I can get 3?

In excel i would filter the data from each set and then add the two cells.

Here is an example

Employee Roster
Employee	Division	Hire Type	Sale Type	Month Hired	Quarter
A	East	Internal	Seller	1	1
B	East	External	Mgr	2	1
C	East	External	Seller	3	1
D	East	External	Seller	4	2
E	West	External	Seller	5	2
F	East	External	Seller	6	2

Pivot table

Hire Type	External
Sale Type	Seller
Quarter	2
Division	Count of Candidate
East	2
West	1
Grand Total	3

 Data set 2- candidate information

To be Hired
Candidate	Division	Hire Type	Sale Type	Hiring Status	Month Hired	Quarter
G	East	Internal	Seller	Offered	1	1
H	West	External	Mgr	Sourced	2	1
I	East	External	Seller	Hired	3	1
J	East	External	Mgr	Offer Accepted	4	2
K	West	Internal	Seller	Future Start	5	2
L	East	External	Seller	Future Start	6	2

Pivot Table

Hire Type	External
Sale Type	Seller
Quarter	2
Hiring Status	(Multiple Items)
Row Labels	Count of Employee
East	1
Grand Total	1

[v-yulgu-msft · Accepted solution]

Hi @anthlen,

According to your description, you want to combine two datasets so that you can sum the total value from each dataset, right?

You can achieve this in Query Editor mode.

1. Filter rows for each table.

2. Append two tables as a new single table.

3. Pivot the new table.

Regards,
Yuliana Gu

[Salvador]

Hi,

You can use measures, use the calculate function to get the data from each table 😄

[anthlen]

Each table has different filters on it.