Sort matrix by column from another table

[Anonymous]

Hi, guys!

Please find below the use case from the end user :

1) Enter a formula.

2) In a matrix, get all formulas that contain at least the same RM (Raw materials) that the formula selected.

3) Sort the matrix by RM to see first the RM of the formula selected (in this case : 1749, 633 B, 712 R 56), then other (no importance of order for others).

For part 2) I duplicate the data table, to filter one with the formula selected, and use the other to display the final result.

Then i create a column "Composition" which concatenates all the values of RM for each formula and used the following measure :

I have some trouble for the part 3).

It look like we can't sort by a measure, only column. And i have no relation between tables because of the filter formula selection.

Is it possible ?

Thanks,

Louis

[Anonymous]

Hi @Anonymous,

I think you can't get input text from filter without any data table source field. AFAIK, power bi filter effect is based on the filtered row contexts, I don't think you can use Dax expression to interaction with these custom strings)

Row Context & Filter Context in DAX / Blogs / Perficient

Regards,

Xiaoxin Sheng