Default value when no filter is selected

[spettinger]

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 

[Anonymous · Accepted solution]

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.