Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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,
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |