Is the returned table from a FILTER, automatically sorted based on the SORT applied in the DATA tab?

[Anonymous]

Hello

Is the returned table from a FILTER, automatically sorted based on the SORT applied in the DATA tab?

If not, how can I sort it based on multiple criteria?

Thanks!

[edhans · Accepted solution]

You would need to use the ORDER BY statement within a DAX query. But your best bet is to sort the visual (Table, matrix, chart) the way you want. The order of the data in the actual table or query is irrelevant to the results. The only time I use ORDER BY is in DAX Studio so I can see the results the way I want, but once I copy my DAX back to Power BI, I remove that and just sort my visuals the way I want.