Measure in Rows

razieh12 — Thu, 28 Sep 2023 15:43:36 GMT

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)

topic Measure in Rows in Custom Visuals Development Discussion

Measure in Rows