show measures in row

[razieh12]

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)

[tamerj1]

@razieh12 

DIVIDE ( SUM ( 'Table'[fac1] ), SUM ( 'Table'[Fac2] ) )

[razieh12]

I want to add this measure in the row . this is the my problem not the calculation 

[tamerj1]

@razieh12 

Little confused. You said it is a matrix right? What did you place in the rows, columnd values?

[tamerj1]

@razieh12 

You did not explain how did you get to this matrix at the first place. 

[razieh12]

I revised the post . 

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)