topic Re: show measures in row in DAX Commands and Tips

show measures in row

razieh12 — Thu, 28 Sep 2023 15:39:47 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)

Re: show measures in row

tamerj1 — Thu, 28 Sep 2023 15:29:13 GMT

razieh12

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

Re: show measures in row

razieh12 — Thu, 28 Sep 2023 15:40:16 GMT

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)

Re: show measures in row

tamerj1 — Thu, 28 Sep 2023 17:47:08 GMT

razieh12

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

Re: show measures in row

razieh12 — Thu, 28 Sep 2023 17:53:16 GMT

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

Re: show measures in row

tamerj1 — Thu, 28 Sep 2023 18:44:49 GMT

razieh12

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