Returns a table of the filter values applied directly to the specified column.
The column for which filter values are to be returned.
A column of unique values.
When FILTERS is evaluated in an expression grouped in SUMMARIZECOLUMNS the original filter could be lost and replaced by the result of the auto-exists behavior that combines all the filters on the same table into a single filter. The combined table resulting from this filter only contains columns explicitly listed in SUMMARIZECOLUMNS as grouping columns or filter columns.
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/filters-function-dax