Forum Discussion
Merging Totals from Different Data Sets
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?
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.
2 Replies
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.
Oh my that's it! I thought I could do it as a Sum= + drawn out DAX. Thank you!
