I have 2 visual matrices that I want to combine together to 1 matrix. Both matrices have the same:
(i) rows ("Resource Group" and "Project Name") and
(ii) values (Demand)
The difference between the 2 matrices is the filtering. I will like to show both filtering in one matrix.
Resource Group --->Project Name | Demand |
^ This is how the projects are divided into resource groups
Matrix 1 below --> filtering is projects containing the title "commercial plan"
| Resource Group | Demand |
| Data Science | 19,695 |
| Electronics | 22,224 |
| Mechanical | 15,788 |
| PMO | 4,310 |
| Product Eng | 7,733 |
| Software | 48,214 |
Matrix 2 below --> filtering is projects exluding the title "holiday plan"
| Resource Group | Demand |
| Data Science | 1,754 |
| Electronics | 914 |
| Mechanical | 73 |
| PMO | 0 |
| Product Eng | 1,564 |
| Software | 5,034 |
I will like the final result to look like:
| Resource Group | Demand (including commercial plan only ) | Demand (all projects excluding holiday plan) |
| Data Science | 1,754 | 19,695 |
| Electronics | 914 | 22,224 |
| Mechanical | 73 | 15,788 |
| PMO | 0 | 4,310 |
| Product Eng | 1,564 | 7,733 |
| Software | 5,034 | 48,214 |
Can this be achieved with DAX?
