FILTERS Function with "S"

[NatashaSchuster]

Hello,

Does anyone have an example of what exactly FILTERS() does ?

Unfortunately, little details on MSDN on this function. 

https://msdn.microsoft.com/en-us/library/gg492172.aspx

[OwenAuger · Accepted solution]

Hi @NatashaSchuster

FILTERS ( MyTable[MyColumn] ) returns a single column of values representing the filters that are applied directly to MyTable[MyColumn] in the current filter context.

For example, if you have applied report/page/visual filters directly on the column MyTable[MyColumn], or added any other filters through slicers or rows/columns etc of a visual, the filtered values of MyTable[MyColumn] will be returned by FILTERS.

But if you have filtered another column that cross-filters MyTable[MyColumn], this does not impact the values returned by FILTERS ( MyTable[MyColumn] ), though it would impact VALUES ( MyTable[MyColumn] ).

Also, any filters added using the CALCULATE/CALCULATETABLE will impact the result of FILTERS.

If no filters at all have been applied to the column, you will get the same result as ALL ( MyTable[MyColumn] ).

As far as I can tell,

FILTERS ( MyTable[MyColumn] )

is equivalent to

CALCULATETABLE (
    VALUES ( MyTable[MyColumn] ),
    ALLEXCEPT ( MyTable, MyTable[MyColumn] )
)

Regards,

Owen 🙂