facing proble in sorting a matrix bt a measure

[AMAN560]

Hello Everyone,

I am facing issues in sorting a matrix by a measure. The problem is as follows:

Table 1
Column A	Column B	Column C	Column D
1223	A	1	12
1223	A	1	3
1223	B	1	42
1223	A	1	1
2236	A	1	3
2236	F	1	5
2236	F	1	7
4652	F	1	6
4652	F	1	4
4652	A	1	1
4652	A	1	3

Table 2
Values	Index
Column C	1
Column D	2
Measure 1	3

Where:

Measure 1 =SUMX(Table1,[Column C] + [Column D])

I have a matrix with the following Field Placement:

Rows: Column A, Column B

Column: Values (Table 2)

Values: Measure 2

Where:

Measure 2=IF(Table2[Index]=1,table1[Column C],IF(Table2[Index=2,Table1[Column D],IF(Table2[Index]=3,[Measure1])))

I got the matrix as follows:

Matrix
Column A	Column B	Column C	Column D	Measure 1
1223	A	3	16	19
1223	B	1	42	43
2236	A	1	3	4
2236	F	2	12	14
4652	A	2	4	6
4652	F	2	10	12

Now I want to sort this matrix by Measure 1

[v-luwang-msft]

Hi  @AMAN560 ,

Could you pls share your pbix file ?

I directly use table1 to create a table, if sorted according to measure1, directly click can:

I was unable to create the same matrix as you did based on the steps you provided, and the matrix I created is as follows:

Best Regards

Lucien

[amitchandak]

@AMAN560 , I think You should be able to see an option in three dots to sort on measure 1

[AMAN560]

NO

[AMAN560]

In my case, the measure name won't show up in 3 dots to sort