Can you reference measures in custom filters?

[LookerExperts]

Knowledge Drop

Last tested: Jan 12, 2021
 

Nope. Our docs mention this here: https://docs.looker.com/exploring-data/filtering-and-limiting#custom-filters 
There is a feature request for this though, please comment!

There is an easy workaround, using a LookML measure type: yesno like so:

measure: testyn {

type: yesno

sql: ${count}<> value or ${users.count} <> 1;;

}

You can then filter on this yesno measure in the explore.

This content is subject to limited support.