Forum Discussion

Cobalt58_9's avatar
Cobalt58_9
Frequent Visitor
2 years ago
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 ...
Need Help
  • audreygerred's avatar
    audreygerred
    2 years ago

    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.

audreygerred's avatar
audreygerred
Super User
2 years ago

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.