Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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,
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 20 | |
| 11 | |
| 10 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 32 | |
| 19 | |
| 12 | |
| 10 |