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
Related Support Forum 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
To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.