Downloads
DAXInformationIntermediate

ISFILTERED

Returns TRUE when a column has a direct filter applied to it.

Syntax
ISFILTERED(<columnName>)

Returns: TRUE or FALSE (a scalar).

What it does

ISFILTERED reports whether a user or a visual has put a filter directly on a column. A slicer on Stores[StoreType] is a direct filter on that column, so ISFILTERED is TRUE for it. It does not report filters that arrive through a relationship from another table, which is the job of ISCROSSFILTERED. Use it to show a note such as "Filtered by store type" or to change a measure when the reader has narrowed the view.

Syntax and arguments

Example

A regional sales report needs a note on the page when the reader has narrowed the view to certain store types, so the totals are not mistaken for the full company.

Scope Note =
IF(
    ISFILTERED(Stores[StoreType]),
    "Note: totals cover selected store types only",
    "Totals cover all store types"
)

If a slicer selects one store type, the first message shows. With no selection, the second message shows. The note is placed in a text card under the total.

Example: a second, different use

Skip a rule that only makes sense for the full population, such as a company-wide benchmark, when a filter is applied:

Company Benchmark =
IF(
    NOT(ISFILTERED(Product[ProductCategory])),
    [Gross Margin %],
    BLANK()
)

The benchmark shows only when the report is not filtered by category, so a partial view does not get compared with the whole company.

Things to watch

In business terms

ISFILTERED keeps a management report honest. When a reader narrows the view, the report can say so, and a company-wide figure is not compared with a partial one. Controllers and auditors look for this kind of disclosure on any pack that changes with the slicers.

Related functions

All DAX functions · View as Markdown · DAX fundamentals