How to use 'ORDER BY' in DAX?

[Redraidas10]

I have a very simple DAX script written, however, DAX engine seems to ignore 'ORDER BY' (as per screenshot below). Any idea how to force DAX engine to take ORDER BY into consideration?

EVALUATE
SUMMARIZECOLUMNS(
    'Table'[Year], 'Table'[Color],
    FILTER('Table', 'Table'[Year] = "2000"),
    "Sales Total", SUM('Table'[Sales])) 
ORDER BY 
      "Sales Total" DESC

[bdmay96]

Sorry for replying to a 4 year old post, but this was the first result when I searched for this problem.

The accepted answer is wrong. The correct ordering they got in their screenshot is just because the Color name is being sorted; the Sales Total ordering is a coincidence. In this case, to sort by Sales Total you need brackets instead of quotes.

 ORDER BY [Sales Total] DESC

[jdbuchanan71]

No, you don't need to include them all every time.
https://docs.microsoft.com/en-us/dax/orderby-statement-dax

[jdbuchanan71 · Accepted solution]

It needs to know how to handle the other columns.  You should also avoid putting FILTER over an entire table, just use the VALUES in the column(s) you want to filter.

EVALUATE
SUMMARIZECOLUMNS (
    'Table'[Year],
    'Table'[Color],
    FILTER ( VALUES ( 'Table'[Year] ), 'Table'[Year] = 2000 ),
    "Sales Total", SUM ( 'Table'[Sales] )
)
ORDER BY
    "Sales Total" DESC,
    'Table'[Color],
    'Table'[Year]

[pelangi]

Nice example. Does it mean that for every "ORDER BY" clause, we have to explicitly mention all columns in that table?