Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to 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
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
@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!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
User | Count |
---|---|
136 | |
70 | |
69 | |
54 | |
52 |
User | Count |
---|---|
207 | |
94 | |
64 | |
61 | |
57 |