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

DOWNLOAD

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.