Visualization filter for 1 column but has expression to filter out specific value for another column

[Ahmed_Shenawy]

im trying to add a visualization filter box with dimension of 1 column, this is pretty straight forward as the expression for it is "=column_name". but also i want to return only the values that are linked to a specific selection from another column. example query below 

SELECT [column_name]

WHERE [Another_column] NOT LIKE '%random%'

[rwunderlich · Accepted solution]

If you can get by with using "*" wildcard instead of "%", you can write it like this:

=Aggr(Only({<[Another_column]= -{"*random*"}>}[column_name]), [column_name])

% is documented as being valid here, but does not work. I think it's a bug.  If you have to use "%", I'm sure there's a workaround

-Rob