Forum Discussion
DAX Query to split multiple measures into two rows on a table/matrix
I'm currently working with direct query and have multiple measures placed into 2 tables e.g. sum and %s.
| Customers Assessed Group A | Score 0 | % | Score 1 | % | Score 2 | % |
| 250 | 20 | 8% | 210 | 84% | 20 | 8% |
| Customers Assessed Group B | Score 0 | % | Score 1 | % | Score 2 | % |
| 10000 | 6000 | 60% | 3000 | 30% | 1000 | 10% |
All of the values come from their own columns of data e.g. of edit query section
| Customers Assessed Group A | Score 0 | Score 1 | Score 2 | Customers Assessed Group B | Score 0 | Score 1 | Score 2 |
| 10 | 0 | 10 | 0 | 3000 | 2000 | 1000 | |
| 100 | 0 | 100 | 0 | 3000 | 2000 | 1000 | |
| 100 | 0 | 100 | 0 | 2000 | 1000 | 1000 | |
| 40 | 20 | 0 | 20 | 2000 | 1000 | 1000 | |
| Total = 250 | 20 | 210 | 20 | Total = 10000 | 6000 | 3000 | 1000 |
As all of these numbers are based on measures is there a way to :
1. Put them all on the same table with two rows e.g.
Desired Outcome
| Customers Assessed | Score 0 | % | Score 1 | % | Score 2 | % |
| 250 | 20 | 8% | 210 | 84% | 20 | 8% |
| 10000 | 6000 | 60% | 3000 | 30% | 1000 | 10% |
OR
2. Add new column that captures the TITLE OF COLUMNS and lets me put specific columns into group A or group B
OR
3. Create a new table with all the measures somehow split into 2 rows (Group A & Group B)
Thanks,
No Replies