Matrix sort row based on column from other table

[Fantmas]

Hi All,

I am facing an issue, I am trying to sort a matrix based on a column from another table

I created this other table based on the original table my issue it is that it return me data except for three rows,

When I am using the column from the original table is display me the data, but when I am using the other table it returns me 0 and I do not understand why,

If you can help me, below a display of my issue (I used the trick to create a sort and add it to my matrix but it increase the calculation time when I am using slicer)

Thanks for your support

[amitchandak]

@Fantmas , Usually we will bring a column into the same table and mark that as the sort column

PowerBI Abstract Thesis Episode 6: How to Create Sort Columns and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8