Forum Discussion
Solved
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 ...
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!