FILTER

Syntax

FILTER(<table>,<filter>)

Tutorial with example

Learn how to use the DAX FILTER function to filter data.

Download example file:

Link to PBI file: here.

Remarks

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.