topic DAX Logical Function for All Selected in DAX Commands and Tips

DAX Logical Function for All Selected

Anonymous — Tue, 29 Jun 2021 17:51:39 GMT

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!

Re: DAX Logical Function for All Selected

selimovd — Tue, 29 Jun 2021 18:42:25 GMT

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

Re: DAX Logical Function for All Selected

Anonymous — Wed, 30 Jun 2021 14:59:30 GMT

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