Append table measures

[sureshcu]

Hi,

I have appended two tables into one. I need sum of two tables separately. however, the measure is picking up  two tables Sum. Can you please help to sum separately. Here is the measure which i have written.

Total HC = TOTALMTD([Total Employees HC],Append1[Reporting Month])

[Anonymous]

Hi @sureshcu,

If you append table contains the group column, you can add a condition to check the current group column value.

After above step, it will shows the separately sum value.

Regards,

Xiaoxin Sheng

[Greg_Deckler]

Couple of ideas on this. Depends on how you did your Append though. If you did "Append as New" you could just sum from your original tables. If you did not, then in your original table, create a column called "Source" and just set it equal to "Source1" create the same column "Source" in your other query but set it to "Source2". When you append the tables then you will know which source each row came from, either Source1 or Source2 and then you can use CALCULATE to FILTER your aggregation.