Hello
I have a question and appreciate if someone provide me with the solution.
My data is 2 tables: Speed Table and Productivity Table.
Speed Table:
City | Column1 | Column2 | Column3 |
A | 1 | 6 | 1 |
B | 4 | 9 | 4 |
C | 0 | 9 | 3 |
D | 1 | 5 | 9 |
A | 8 | 7 | 0 |
B | 9 | 1 | 6 |
C | 0 | 7 | 4 |
D | 1 | 8 | 3 |
Productivity Table:
City | Fac1 | Fac2 |
A | 1 | 6 |
B | 4 | 9 |
C | 0 | 9 |
D | 1 | 5 |
A | 8 | 7 |
B | 9 | 1 |
C | 0 | 7 |
D | 1 | 8 |
And I want to create this matrix from these tables
by grouping by the data of speed table and productivity tables and pivoting them and appending these two table I can create the below matrix:
My main challenge is the Fac1/Fac2. I dont know how to add this measure in the maxtrix. I appreciate it if some one can help me. Fac1/Fac2 means divide( Fac1,Fac2).
the values in matrix is the calculate (sum( column1)), calculate (sum( column2)),calculate (sum( column3)),calculate (sum( fac1)),calculate (sum( fac2)), divide( Fac1,Fac2)
Helpful resources
Data Days 2026
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
