Forum Discussion
Is there a SELECTED button DAX function?
When you're working with bookmarks you can have them remember the state of filters, slicers etc.
You could create a disconnected table containing rows for button A, B & C. When the appropriate button is active make sure that a filter is applied on the disconnected table and at the same time clear the selections on the other slicers. You can then use SELECTEDVALUE on the disconnected table to determine which button is active.
Hi WishAskedSooner, try one of these:
ISFILTERED – DAX Guide
ISCROSSFILTERED - DAX Guide
FILTERS - DAX Guide
Good luck with your project! 🙂
Sergii24 ,
Thank you so much for your prompt reply!
I am uncertain if the FILTER functions above will work. For example,
A user clicks Button B and makes a selection in Slicer B. Next, the user clicks Button A, but does not clear Slicer B before doing so. Then, the user makes a selection in Slicer A.
Thus, both Slicers A and B will be filtered. In thinking some more about this scenario, if there was a way to programmatically clear the slicers when they click one of the buttons, maybe that would work? But, I don't know how to go about doing that.
So, your thoughts?
I am very curious on how others have designed solutions for this business requirement.
TIA!