IF function

[devsharma6830]

How to get "Blank" when nothing is selected on slicer in the below given case :

Finsihin Date = IF(CALCULATE(VALUES(Data[Finish Date])) = Blank (), "Worknig", FORMAT(VALUES(Data[Finish Date]), "D/MMMM"))

[Ahmedx]

pls try this

this is all just an example

IF( not ISFILTERED(VALUES(Data[Finish Date]) ,"Blank",FORMAT(VALUES(Data[Finish Date]), "D/MMMM")))

[devsharma6830]

thanks but not working

[VijayP]

@devsharma6830 
slicer values always come from a field but not from a measure!

Hence try using SELECTEDVALUE Function. 

[devsharma6830]

I tried but not appropriate result