topic Re: DAX Measure to Return Information on Slicer Selection/Slicer Status in DAX Commands and Tips

DAX Measure to Return Information on Slicer Selection/Slicer Status

Anonymous — Tue, 17 Aug 2021 19:17:12 GMT

Hello, I'm trying to write a DAX measure that will assist the report user in understanding what has been selected on a slicer. I would like the DAX measure to return 1 of 4 possible conditions:

If all slicer options are selected, return "All selected"

If no slicer options are selected, return "Make a selection"

If one slicer option is selected, return "One selected"

If more than one (but not all) options are selected, return "Multiple selected"

I've tried to get there with a combination of IF statements, SELECTEDVALUE, ISFILTERED, HASONEVALUE, etc. but can't get the logic to work right.

Thank you!

Re: DAX Measure to Return Information on Slicer Selection/Slicer Status

Greg_Deckler — Tue, 17 Aug 2021 19:27:16 GMT

Anonymous See if this helps: The Most Amazing, Mind Blowing Dynamic Slicer Titl... - Microsoft Power BI Community

Re: DAX Measure to Return Information on Slicer Selection/Slicer Status

Jihwan_Kim — Wed, 18 Aug 2021 09:53:18 GMT

Link to the sample pbix file

Re: DAX Measure to Return Information on Slicer Selection/Slicer Status

Anonymous — Mon, 23 Aug 2021 15:22:18 GMT

Thank you very much - this was very helpful!

Re: DAX Measure to Return Information on Slicer Selection/Slicer Status

Anonymous — Mon, 23 Aug 2021 15:22:36 GMT

Thank you - this was very helpful!