Measure filters not working with more than one "-Negative" Filters

Looker Q&A Looker
1

measure: total_gross_revenue {
type: sum
sql: ${amount};;

filters: [invoice_item_types.name: "-CREDIT_TYPE", invoice_item_types.name: "-DISCOUNT_TYPE" ]

Does not make either of the filters work.

measure: total_gross_revenue {
type: sum
sql: ${amount};;

filters: [invoice_item_types.name: "-CREDIT_TYPE"]

Works as expected. Is this expected behaviour?

1 Like
2

Because you are filtering by the same dimension you can filter multiple values by comma separating them e.g.

filters: [invoice_item_types.name: "-CREDIT_TYPE, -DISCOUNT_TYPE"]