Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX Logical Function for All Selected

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!

  • selimovd's avatar
    selimovd
    5 years ago

    Hey Anonymous ,

     

    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
     

2 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey Anonymous ,

     

    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
     
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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."