Testing if a column is filtered by a slicer

[cr731]

In a DAX measure, is it possible to distinguish between a filter to a column applied by a slicer versus by the field being in the row labels? For instance, if I have a table with values such as

Fruit
Apple
Banana
Orange

And I pivot that dragging the Fruit column into rows ... if I write a calculated field

=ISFILTERED([Fruit])

This will return True for each row.

I also have a slicer applied to the table on this column, and what I really want to know in my calculated field is whether the slicer is filtered. Is this possible?

Thanks

 

[akice]

Don't think so. Dax engine isn't even aware there are slicers, filters, or even a pivot for that matter. It just applies the filtering algorithm per its internal rules. if you have the same column in row and slicer there isn't a way to distinguish that I know of.