# FILTERS

Returns the values that are directly applied as filters to columnName.

## Syntax

FILTERS(<columnName>)


### Parameters

Term Description
columnName The name of an existing column, using standard DAX syntax. It cannot be an expression.

## Return value

The values that are directly applied as filters to columnName.

## Remarks

This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

## Example

The following example shows how to determine the number of direct filters a column has.

= COUNTROWS(FILTERS(ResellerSales_USD[ProductKey]))


This example lets you know how many direct filters on ResellerSales_USD[ProductKey] have been applied to the context where the expression is being evaluated.