How to make it as 0 instead of Blank in slicer using DAX Measure

[saivina2920]

I am using the following DAX measure in slicer.

If the count is zero, i am getting "[Blanl]" text in my slicer. 

Instead of "[Blank]", i just want to display "0" Zero count in slicer. How to do this.

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"))

[vanessafvg · Accepted solution]

you can probably do a +0 at the end of your measure or do a if(isblank)

ie

if(isblank(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")),

0, 

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]

Thanks. It's perfect.