Forum Discussion
afaro
Helper III
Helper IIICan I sort matrix visual based off a specific column?
Let's say I have table like this: Country C1 C2 C3 Product Sales Sales Sales P1 10 20 50 P2 30 10 60 P3 50 0 10 Product is the rows in the matrix, Country is...
I showed that in my measure, with ISINSCOPE.
afaroHelper III
Helper IIIHow did you change the column total to only include C2? I do not get that point.
What I tried to do was create a new measure just for sorting. This measure would calculate the value based on the value in the slicer and not the column value coming from the matrix. However, for this I had to disconnect the matrix from the slicer but when I did this, the new measure created for sorting no longer works since disconnection led to me not being able to read the value of the slicer using SELECTEDVALUE.
lbendlin
Super User
Super UserI showed that in my measure, with ISINSCOPE.