cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sureshcu Helper I
Helper I

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

2 REPLIES 2
Super User IV
Super User IV

Re: Append table measures

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.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Community Support
Community Support

Re: Append table measures

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

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors