Sum data from different tables based on rows value

[lucaivox]

Hello everyone,

What I'm trying to do here is to create a table with all countries that summarize music seconds. The data come from 2 different sources so I want to built a middle table like this:

My goal is to build a Filled map that shows seconds from all countries, but so far I could only reach this:

So seconds are not in the same column.

How can I do this?

Thank you!

Best Luca

[mahoneypat · Accepted solution]

Two ways you could address this. First would be to transform your tables so you could append them (harder) but the simpler way would be to make a new measure that adds the two values.

NewMeasure = SUM(Table1[Duration]) + SUM(Table2[Duration])

Pat

[lucaivox]

Hello Pat,

thank you! the 2 sources are too different from each other to merge them. I'd have too many blank columns and loss of info.

I went for the measure idea, that worked perfectly. Thank you so much!