DAX Logical Function for All Selected

[mstone3]

Hello,

Is there a DAX function that will return a logical true/false based on whether or not all slicer options are selected?  I.E. if all slicer options are selcted (all selected), result = TRUE.  If not all options are selected = FALSE.

Thanks!

[Anonymous]

Function? No. But a combination of functions - yes. Assuming the slicer can't have any filtering applied to itself, that is, no measure filters it via the Filter pane and assuming that the slicer holds data from one column only from table T, what you can do is write this measure:

[All Entries Selected] =
var SelectedEntriesCount =
    DISTINCTCOUNT( T[SlicerColumn] )
var TotalEntriesCount =
    CALCULATE(
        DISTINCTCOUNT( T[SlicerColumn] ),
        REMOVEFILTERS( T )
    )
return
    SelectedEntriesCount
        = TotalEntriesCount

Of course, if you had a measure filtering the slicer it would also be possible to write such a measure but it would be a bit more complex. It would also require defining what is meant by "all entries selected."

[selimovd · Accepted solution]

Hey @mstone3 ,

yes, the function is called ISCROSSFILTERED.

The following measure will return a TRUE or FALSE if a specific column is filtered or not:

IsFiltered = ISCROSSFILTERED( mySlicerTale[SlicerColumn] )

This you can use then in other measures (IF( ISCROSSFILTERED( ...))

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic