ISFILTERED function


#1

Hi Guy,

Will the ISFILTERED result be True when the column in question has been used in a FILTER function.

I don’t understand how ISFILTERED works. Is there a video I can watch. I was not able to locate a video on ISFILTERED. There is not much on google.

Cheers
E


#2

Elizabeth,

Yes it does.

Look at this - https://dax.guide/isfiltered/

I couldn’t find a video produced by Sam but there are others on YouTube by other people that are pretty good.

Try - https://www.youtube.com/watch?v=DqehDO50mFE

Guy

Enterprise%20DNA%20Expert%20-%20Small


#3

Elizabeth,

I did find a video on ISFILTERED by Sam.

Guy

Enterprise%20DNA%20Expert%20-%20Small


#4

Hi Guy,

Am I correct to say the functions is all about if a relationship exist between the tables.

Cheers
Elizabeth


#5

Elizabeth,

I believe so. This is from a DAX guide I use - https://dax.guide/

A column is said to be filtered directly when the filter or filters apply over the column.
A column or table is said to be cross-filtered when a filter is applied to any column of the same table or in a related table.

ISFILTERED returns TRUE or FALSE depending on whether the column passed as an argument has a direct filter on it, that is, it has been put on rows, columns, or on a slicer and the filter is for the current cell. This occurs between tables with a relationship such as Data and Product[Category] as an example.

Guy

Enterprise%20DNA%20Expert%20-%20Small