Forum Discussion

sureshcu's avatar
sureshcu
Helper I
9 years ago

Append table measures

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])

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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