Forum Discussion

Dellis81's avatar
Dellis81
Icon for Post Prodigy rankPost Prodigy
5 years ago

Table Sort - Can't be more than one value...

Hello - I am needing help sorting a matrix visual, where the displayed row has common ReportLine value, but account drill down provides the greater detail.    First screenshot is the underlying tabl...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Dellis81 , A calculated column can not use selected value or slicer value.

 

 

Dellis81's avatar
Dellis81
Icon for Post Prodigy rankPost Prodigy
5 years ago

Thank you for your thoughts.   Even though I am using "selectedvalue" within the measure, the result of the calculated column/measure appears to be correct - and allows for proper sorting.     Possibly this second screenshot shows the problem I now have with matrix visual.  The items grouped in blue should be condensed to a single row.   If I remove the calculated column, then the sorting option results in an error.  Thank you!