FILTER

« Back to Glossary Index

Syntax

FILTER(<table>,<filter>)

Tutorial with example

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

Links to the mentioned resources

To get the files:
1. Go to Curbal Download Center > Community Downloads
2. Get File #6

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.

Additional Resources

When should I use FILTER() with CALCULATE?

« Back to Index