sort by another column error

[datacollection]

I checked my data with dax viewr.  there no duplicate values.

[datacollection]

Issue is with Power BI April24 desktop release.
For same dataset in March24 desktop release I am not facing any issue.

[Anonymous]

@DataNinja777  Thanks for your contribution on this thread.

Hi @datacollection ,

It appears that the issue may have originated from the version of Power BI Desktop in use. Recently, a new version of Power BI Desktop has been released. We kindly request you to verify if the problem persists with this latest version. If the issue has been resolved, we would appreciate it if you could mark your post as ‘Answered’. Thank you for your cooperation.

Download Microsoft Power BI Desktop from Official Microsoft Download Center

Best Regards

[DataNinja777]

Hi @datacollection 

Do you have the same number of distinctcount output for those two rows?  In order to sort the column by another column, this has to be the case.  

Best regards,

[DataNinja777]

Hi @datacollection 

In order to use the sort by column, your sort by column should have the same number of unique values as the sorted column, so that there's no ambiguity when sorting.  

Best regards,

[datacollection]

there is no ambiquity when sorting. i checked data with dax query view

[datacollection]