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

FILTERS(
     <columnName>
)

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

Keep all the filters of slicers on all the pages
Cascading filters
ALL not ignoring filter – example attached

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]))

=COUNTROWS(FILTERS(ResellerSales_USD[ProductKey]))

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership