Forum Discussion

jcesguerra's avatar
jcesguerra
New Member
2 years ago
Solved

Error message when sorting by another column

Hi I used to be able to sort a column by an aorder set in another column with no problem But now I get this error message: "We can't sort the 'X' column by 'Y'. There can't be more than one value in...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    jcesguerra Sorry, let me try again:

     

    - add a table visual

    - add the column that you are trying to sort

    - add the column that you are using for sorting

    - add the following measure in the table visual

     

    Measure = DISTINCTCOUNT ( Table[SortByColumn] )

     

    click on the Measure heading in the visual to sort by measure, and see if there is any value which is greater than 1 and that where the problem lies.