Knowledge Drop

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

  • 7 July 2021
  • 0 replies
  • 43 views

Userlevel 4

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!

Reply