Forum Discussion
Calculate and filter
Hi, Im trying to use the following DAX functions but I get an error. Expenses = Calculate ( [Transaction Amount], FILTER ( transactions[Type] = "debit" ), transaction...
Hi the first argument of the Filter function should be a table, but its also not needed if the measure you calculate is the table you want to filter, try this:
Expenses =
Calculate (
SUM([Transaction Amount]),
transactions[Type] = "debit" && transactions[Category] NOT( IN { "transfer","Credit Card Payment",""})
)