Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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%'
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
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