FILTER Returns a table that represents a subset of another table or expression.




Table – The table to be filtered. The table can also be an expression that results in a table.

Filter – A Boolean expression that is to be evaluated for each row of the table. For example, [Amount] 0 or [Region] = “France”

Return Value

A table containing only the filtered rows. You can use FILTER to reduce the number of rows in the table that you are working with, and use only specific data in calculations. FILTER is not used independently, but as a function that is embedded in other functions that require a table as an argument.

Reference Data

DAX Functions / Filter Functions / FILTER