FILTERS Function (DAX)

How does the FILTERS function (DAX) work?

The FILTERS function (DAX) returns the values that are directly applied as filters to columnName.

FILTERS Formula Syntax


How do you use the FILTERS function?

Can be used in applying filters to the Excel spreadsheet can save you large amounts of time and clearly present the information you are looking. No matter how large or small the amount of data you have, filters sort through an Excel column and can break down an overwhelming data table.

Related Blog Posts


Considerations when using the FILTERS function

If you need to filter through a long list of names for a webinar and find the first 25 registrants, you can sort the registration date column from oldest to newest.

Another example is if you need to sort through the test grades of a Physics exam and count how many students scored above a B+. From the drop-down filter menu, you can apply filters to the test grade column to exclude the students that scored lower than a B+.

Related Video Tutorials

Formula examples using the FILTERS function

= COUNTROWS (FILTERS (Sales[Region]))



Related Course Modules