Forum Discussion
SortByColumn SSAS not working
I am in SSAS: I have column Name, but I want to sort by Id because when in Power BI, it automatically groups by people with same name, but they are in fact different people. I have 2 tables: Cl...
The cause of the error, as you described.
If there are multiple different values for the same item, it cannot be sorted by the column.
What we can try to do is to modify one item corresponding to one value by concatenate different columns, so that we can use SortByColumn.
Here is a sample, hope it will help you
V-lianl-msft
Community Support
Community SupportThe cause of the error, as you described.
If there are multiple different values for the same item, it cannot be sorted by the column.
What we can try to do is to modify one item corresponding to one value by concatenate different columns, so that we can use SortByColumn.
Here is a sample, hope it will help you