How to Exclude blank date of START_DATE in Filter using DAX Measure

[saivina2920]

I am excluding the blank values of my column START_DATE. but, i am not sure this is the correct syntax or not.

pls. help us to proceed further.

MEASURE1 = 
vToday = TODAY()
vCalDate20 = EMP_TABLE[vToday] - 20
CALCULATE(DISTINCTCOUNT(EMP_TABLE[EMP_NO]),FILTER(EMP_TABLE, 
 EMP_TABLE[START_DATE]  <= (EMP_TABLE[vCalDate20]) && NOT EMP_TABLE[START_DATE] IN {""} &&
 EMP_TABLE[EMP_STATUS] = "Active"))

condition is ==> NOT EMP_TABLE[START_DATE] IN {""} ==> Not working

[amitchandak · Accepted solution]

@saivina2920 , Try isblank ,

corrected few syntaxes

MEASURE1 =
vToday = TODAY()
vCalDate20 = vToday - 20
return
CALCULATE(DISTINCTCOUNT(EMP_TABLE[EMP_NO]),FILTER(EMP_TABLE,
EMP_TABLE[START_DATE] <= (EMP_TABLE[vCalDate20]) && NOT(isblank(EMP_TABLE[START_DATE])) &&
EMP_TABLE[EMP_STATUS] = "Active"))

[saivina2920]

I am getting if count is zero as "[Blanks]". I want to display as "0" instead of "[Blank]".

How to achieve this..?

[saivina2920]

any update..

[saivina2920]

Thanks for your help..It's working.