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?
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"]