Knowledge Drop

What is the matches (advanced) filter expression syntax for not applying a filter at all?

Userlevel 5

Last tested; May 12, 2020

<=0 OR >0 OR NULL for numbers, %,NULL for strings.

To get all non-null values, see How do I filter out null in a filtered measure?

Here are expressions that DON'T work:

NULL, NOT NULL for numbers and NULL,-NULL for strings generate AND between the two parts, so no values will be returned. NULL OR NOT NULL cannot be parsed as a filter expression.


This content is subject to limited support.                



0 replies

Be the first to reply!