I have a card that I want to show nothing if slicer is empty

[mehlenbae2]

I have a slicer that lists a bunch of names that can be selected (one name at a time). I have a card below the slicer that is supposed to show the location of the person selected in the slicer. However, when nothing is selected in the slicer I want the card to show nothing at all or <blank>. At the moment it shows the last location of the person last selected in the slicer - it should be blank as the slicer has no names selected. How can I achieve this? 

I am new at DAX and have no clue how to do this. Any help would be great. 

[Anonymous]

Hi,

I think this could be solved by using: 

Measure1 =
CALCULATE ( IF ( ISFILTERED ( Table[Column] ), 1, 0 ), ALLSELECTED ( Table ) )

 I found this on: https://community.powerbi.com/t5/Desktop/Show-blank-when-nothing-is-selected-in-the-slicers/m-p/6729...

Please mark as solved if this helps 🙂 

[jdbuchanan71 · Accepted solution]

@mehlenbae2 

If you add a measure to show the location it should work the way you want.

Person Location = SELECTEDVALUE ( YourTable[Location] )

Then you put this measure in the card.

[mehlenbae2]

This worked perfectly. Thank you!