Filter and Sortby need to be coordinated
Dynamic array functions Filter and Sortby should be coordinated.
So I want to filter and sort a list of values from a table. For example, I want the list of values Table1[ID] filtered where Table1[Date] <> "" sorted by Table1[Customer].
If you want to return all referenced values you can do SORT(FILTER(Table1[ID]:[ColZ],Table1[Date]<>""),2,1) assuming column 2 is [Customer] but if you only want Table1[ID] returned this won't work.
To use SORTBY and FILTER you have to put SORTBY inside FILTER (not consistent with SORT(FILTER ) and then for every FILTER condition you have to use the entire SORTBY reference. So this is FILTER(SORTBY(Table1[ID],Table1[Customer],1),SORTBY(Table1[Date],Table1[Customer],1)<>""). Now imagine you have 5 sorts and you want to filter on multiple conditions ...
If you do not put the entire SORTYBY function for each condition you will get a list of filtered values but they will not be the correct list.
Seems logical that by default FILTER and SORTBY would be coordinated such that the SORTYBY would default to the filtered list or the FILTER would default to the SORTBY list without having to duplicate the entire SORTBY function for each condition in the FILTER.