Forum Discussion

lg1551's avatar
lg1551
Icon for Resolver II rankResolver II
3 years ago
Solved

Use a Default Measure When Slicer is Set to 'All'

I have a Quarter/Month Hierarchy Slicer.   By Default, the slicer is set to "All", meaning nothing is selected in the slicer. When it is in this state, I want the visual to display a specific measu...
Need Help
  • lg1551's avatar
    lg1551
    3 years ago

    Thanks for the reply. I was actually able to get this sorted out. 

     

    What I was after, was for the visual to use a default measure, when the slicer has nothing or "All" selected. I was able to achieve this via some DAX.

lg1551's avatar
lg1551
Icon for Resolver II rankResolver II
3 years ago

Thanks for the reply. I was actually able to get this sorted out. 

 

What I was after, was for the visual to use a default measure, when the slicer has nothing or "All" selected. I was able to achieve this via some DAX.

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
3 years ago

lg1551  Can you please share the DAX that you've used so others can benefit? I'd also be interested to learn how it differs from the DAX I suggested to you. 

 

Thanks! and glad you got it solved.