Forum Discussion

dfox09's avatar
dfox09
Icon for Helper III rankHelper III
4 years ago
Solved

Set the default value for slicer to 0

Here is the DAX for a Slicer that I am using to show revenue amount based on a carrier selected. If no carrier is selected, ir shows the total value for all of the carriers. How do I get the default ...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi dfox09 ,

     

    You can try this:-

    measure =
VAR result =
    CALCULATE (
        MAXX ( 'FactRFP', [Total Annual Premium & FeesCURRENT] ),
        REMOVEFILTERS ( 'DimCarrier' )
    )
RETURN
    COALESCE ( result, 0 )
--or you can try below
--if(result = blank(),0,result)
--or
--result+0

     

    Thanks,

    Samarth

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

dfox09  Based on sevenhills  suggestion below would be your ideal code:-

measure =
VAR _ValueCalculated =
    CALCULATE (
        MAXX ( 'FactRFP', [Total Annual Premium & FeesCURRENT] ),
        REMOVEFILTERS ( 'DimCarrier' )
    )
RETURN
    IF ( ISFILTERED ( DimCarrier[Carrier] ), _ValueCalculated, 0 )
dfox09's avatar
dfox09
Icon for Helper III rankHelper III
4 years ago

That worked! Thank for your suggestion. I will note this and the one you suggested below.