Matrix Visual: Combining columns from 2 tables

[Tom_Y]

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]

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!

[Anonymous · Accepted solution]

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