Calculate the sum in table 2 based on table 1, show the summaries of both tables in the same matrix

[JeremiahMason]

I have two tables that are of the same layout but contain different values. Essentially, I just want to combine two arrays into a /show the result of the summaries of each table into a single visual. The example below shows the visuals I have and what I'm trying to produce, rather than the data itself, that is, the arrays shown below are a summary of my much larger data.

have:

Table 1 Matrix 1

Category	Dollars
B	10
C	10
D	15
E	20

Table 2 Matrix 2

Category	Dollars
B	5
C	15
D	10
E	0

I want to:

An array that shows both summaries in a single visual

Category	T1 Dollars	T2 Dollars
B	10	5
C	10	15
D	15	10
E	20	0

I tried to use DAX to create a variable in table 1 that sums table 2 dollars based on my table 1 categories, but this failed.

Table2_Dollars de cálculo( SUM( 'Table2'[Dollars], FILTER( 'Table2', 'Table2'[Category] ? CALCULATE( VALUES( 'TABLE1'[Category]))))

Thank you in advance!

[v-deddai1-msft · Accepted solution]

Hi @JeremiahMason ,

Would you please try to create a measure for T2 Dollars:

T2 = CALCULATE(SUM('Table (2)'[Dollars]),FILTER(ALL('Table (2)'), 'Table (2)'[Category] in DISTINCT('Table'[Category])))

---

---

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[parry2k]

@JeremiahMason you should create  a category table with unique values that is related to these tables with one to many and then add a measure for each table, in visualization, use category from this new category table and measures for each table

T1 Dollars = SUM ( Table1[Dolloars] )

T2 Dollars = SUM ( Table2[Dolloars] )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!