Forum Discussion

shtefanvalery's avatar
shtefanvalery
Frequent Visitor
8 years ago
Solved

Sort by another column (by duplicate values)

Hello, community.    There is a problem: for example, i've got a Table with columns: Name, JobT, Department, Salary. I need to sort it in Mullti-row card by Salary, but don't show that values there...
Need Help
  • shtefanvalery's avatar
    shtefanvalery
    8 years ago

    Hi v-jiascu-msft,

     

    I found somewhere, that i cannot do "sort by column" for duplicate values, so i thought that it was my problem. But, i found a solution.

     

    I had an error "This column can't be sorted by a column that is already sorted, directly or indirectly, by this column". And it means, that you can't sort by a calculated column which DAX expression depends on the column you want to sort. I duplicated a column and everything works fine. It's a bit confusing..

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi shtefanvalery,

 

You still can do "Sort by column" when salary has duplicates. Do you have any other requirements?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

shtefanvalery's avatar
shtefanvalery
Frequent Visitor
8 years ago

Hi v-jiascu-msft,

 

I found somewhere, that i cannot do "sort by column" for duplicate values, so i thought that it was my problem. But, i found a solution.

 

I had an error "This column can't be sorted by a column that is already sorted, directly or indirectly, by this column". And it means, that you can't sort by a calculated column which DAX expression depends on the column you want to sort. I duplicated a column and everything works fine. It's a bit confusing..