Forum Discussion
Solved
Filter a measure using value from another slicer
Hello , I am trying to filter the value of a card with the selectedvalue from a slicer. I have a slicer using the country field whose value I obtain by using selectedvalue. I am then trying ...
What do you want to show if nothing is selected in the slicer?
You could use an if statement and hasonevalue to determine if the slicer has a single selection. If it doesn't, then return whatever default value you want.
https://learn.microsoft.com/en-us/dax/hasonevalue-function-dax
You could also try using chiclet slicer (download the visual) and force a selection in the slicer so it is never blank.
Many thanks for the suggestion..