[HELP NEEDED] Changing a formula generating a table expression into one generating a column expres

I want to be able to use VALUES or DISTINCT with FILTER.   A lot of workarounds (i.e. Calculatetable + Filter or SELECTCOLUMNS + Filter) dont work as the output is still a TABLE expression.    I ...