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.

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

lg1551 

 

You need to determine how many values the slicer has without filters, then compare to how many it has in current context:

 

Measure = 
VAR _CountAllOptions = CALCULATE( countrows( values ( table[column] ) ), ALL() )

VAR _CountCurrentOptions = countrows( values ( table[column] ) )

VAR _Result = IF( _CountAllOptions = _CountCurrentOptions, [Default Measure], [Other Measure] )


RETURN
_Result

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.