Forum Discussion

spettinger's avatar
spettinger
Frequent Visitor
4 years ago
Solved

Default value when no filter is selected

I have a table with a few different data points (shown below). I have a slicer to filter the dashboard by the trade, but when a trade is not selected, I need my card to show the data for trade "x" 

 

This is not the average or sum.

 

 

I tried the below measure, and it shows 30.80216981 when no trade is selected (YAY), but when I select "Boilermaker" on the slicer, the card visual goes "Blank" when I need it to show 21.3209 

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi spettinger ,

     

    I create a sample and have a test by your code. I think your code should be correct, it works well in my sample.

    My Sample:

    Code:

    ROUND = 
IF (
    ISFILTERED ( Overview1[TRADE] ),
    SELECTEDVALUE ( Overview1[SPI $] ),
    CALCULATE ( SELECTEDVALUE ( Overview1[SPI $] ), Overview1[TRADE] = "X" )
)

    Result is as below.

    By default:

    Select "Boilermaker":

    Please check whether there are some other filters in your data model.

    You can download my sample to compare mine with yours.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi spettinger ,

     

    I create a sample and have a test by your code. I think your code should be correct, it works well in my sample.

    My Sample:

    Code:

    ROUND = 
IF (
    ISFILTERED ( Overview1[TRADE] ),
    SELECTEDVALUE ( Overview1[SPI $] ),
    CALCULATE ( SELECTEDVALUE ( Overview1[SPI $] ), Overview1[TRADE] = "X" )
)

    Result is as below.

    By default:

    Select "Boilermaker":

    Please check whether there are some other filters in your data model.

    You can download my sample to compare mine with yours.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.