Change a card value to Blank when filter is selected

[Tushar_Pasricha]

Hi All,

I am trying to change a card value on dashboard to turn Blank when I select a particular filter.

Case : All values are Selected in a Type of booking filter ( Default)

A card value (Target) is shown on my dashboard

Task: When a user selects Offline, The target value should show as blank

We have used If condition to turn this to blank but that is not working, could anyone please help in resolving this

[amitchandak · Accepted solution]

@Tushar_Pasricha , use isfiltered

if(isfiltered(Table[Column]) , [Measure], blank())

or

= var _is = calculate(isfiltered(Table[Column]), allselected())

return

if(_is , [Measure], blank())

HasOneValue , Isfiltered: https://www.youtube.com/watch?v=hXg3kRFSGjA&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=38