SortByColumn SSAS not working

Anonymous — Thu, 15 Jul 2021 13:57:58 GMT

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: Clients and Current Client.

Client is a table and Current Client is a calculated table…

I am able to do it in Client, but not in the calculated table Current Client, Why is this? I get the error….

Cannot sort Name by Id because at least one value in Name has multiple distinct values in Id. For example, you can sort [City] by [Region] because there is only one region for each city, but you cannot sort [Region] by [City] because there are multiple cities for each region…

Well, yes, that’s the very reason I want to sort!!

Re: SortByColumn SSAS not working

V-lianl-msft — Mon, 19 Jul 2021 07:12:39 GMT

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

topic SortByColumn SSAS not working in Developer

SortByColumn SSAS not working

Re: SortByColumn SSAS not working