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
Join our Community Sticker Challenge 2026
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Power BI Monthly Update - January 2026
Check out the January 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
