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

[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?