Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Tom_Y
Advocate II
Advocate II

Matrix Visual: Combining columns from 2 tables

Hi all,

What I want is to combine that 2 columns, and add up the counts.

This is the settings and this is the result. 

The Values are date, one from each of the Project Table.

Installed measures are e.g. Apple, Banana, Orange, linked to "Meausres Table". (Very similar for both projects)

Both project tables linked to "Date Table".

Will the columns simply combine if I combine both table, or making one more "Project tables" putting "Project H, G" and link everything?

Or is there any easy method? There'll be 10 more projects loading into this Matrix. I dont' want to append that 10 projects into one table.

 

Thanks in advance.

Tom_Y_2-1703167029070.png

 

Tom_Y_1-1703167003855.png

 

 

Tom_Y_0-1703166934719.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

HI @Tom_Y,

I'd like to suggest you create a new table with these field names, then you can use it as column of matrix and write a measure formula with switch function to check current row contents to redirect to different expressions.

Write Conditional Statement Using SWITCH in DAX and Power BI - RADACAD

Regards,

Xiaoxin Sheng

View solution in original post

2 REPLIES 2
Tom_Y
Advocate II
Advocate II

Is there anything better way than doing DAX like this? We're going to have other projects in future so I'll need to have one DAX in each project table, and then revising this "Total installed" measure?

Or is it quite normal in the power BI world? I'm quite new.

Thank you!

Tom_Y_1-1703183649912.png

 

Tom_Y_0-1703183479090.png

 

Anonymous
Not applicable

HI @Tom_Y,

I'd like to suggest you create a new table with these field names, then you can use it as column of matrix and write a measure formula with switch function to check current row contents to redirect to different expressions.

Write Conditional Statement Using SWITCH in DAX and Power BI - RADACAD

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.