How to make Selector "Blank" show all instead of none

When filtering using a dropdown selector with single select think I’ve found a way to make the selector show everything instead of nothing: when selecting [Blank].

If([Select Name]=“”,True(),thisRow.[Column].Matches([Select Name]))

Using this formula, the filter will use the selector unless blank (“”) is selected.

As I find the multiple selector a bit complicated to use, this should be a good alternative.

4 Likes

Thank you for your tip
can you make sample doc for this

iam trying to do but it doesnot work