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

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 1 588
1 REPLY 1

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"]
Top Labels in this Space
Top Solution Authors