Forum Discussion
Matrix sort row based on column from other table
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
1 Reply
- amitchandakSuper User
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-crefer 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