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
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
Elizabeth,
I did find a video on ISFILTERED by Sam.
http://portal.enterprisedna.co/courses/108877/lectures/2000620
Guy
Hi Guy,
Am I correct to say the functions is all about if a relationship exist between the tables.
Cheers
Elizabeth
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