Merging Totals from Different Data Sets

[Cobalt58_9]

I'm stuck.

I have four different Tables:

Each of those has a column titled "Count." I've made Table visuals showing the breakdowns and the overall total.

My question is how can I take those grand totals from the "Count" columns and combine them into one table?

I've tried making a new table, with the the sum=wave1[count] DAX and so on, but kept getting a message of "The SUM function only accepts a column reference as an argument."

What am I missing?

[Cobalt58_9]

Oh my that's it! I thought I could do it as a Sum= + drawn out DAX. Thank you!

[audreygerred · Accepted solution]

Are you wanting to show the sum of teh counts from all 4 tables?

You can create explicit measures for each:

Count Wave 1 = SUM('Wave 1'[Count])

Count Wave 2A = SUM('Wave 2A'[Count])

Count Wave 2B = SUM('Wave 2B'[Count])

Count Wave 3 = SUM('Wave 3'[Count])

Total Count = [Count Wave 1]+[Count Wave 2A]+[Count Wave 2B]+[Count Wave 3]

Also, you should have a star schema in place, that way any dimesnions come from dimension tables and these can be shared between the fact tables.