return 0 when the value is blank

[amalrio]

Hi helpful people,

I have below measure counting a text field, I need to return 0 when field value is blank, Below is the measure I created.

=======

TSF Facility in Use =

VAR Total = CALCULATE(

COUNT('FACT-Data'[TEXT]),

KEEPFILTERS('FACT-Data'[TEXT] <> BLANK())

)

VAR Result = IF(Total = BLANK(), 0, Total)

RETURN

Total

========

In the Test M, i need 0 when the count is blank. my formula does not work the way I want when I put if conditions other Matrix names come up in the visual (table). I need only to show the 0 for this selection (as in the tabel)

[RichardElmer]

+0  So Simple.... Thank you

[amitchandak]

@amalrio , in the return you can add +0

RETURN
Total +0

Or

RETURN

if(isblank(Total),0,Total)

[manikumar34]

@amalrio 

Modify with ISNULL

TSF Facility in Use =
VAR Total = CALCULATE(
COUNT('FACT-Data'[TEXT]),
KEEPFILTERS('FACT-Data'[TEXT] <> BLANK())
)
RETURN
IF(OR(ISBLANK(Total),ISNULL(Total)), 0, Total)

[themistoklis · Accepted solution]

@amalrio 

Try the following:

TSF Facility in Use =
VAR Total = CALCULATE(
COUNT('FACT-Data'[TEXT]),
KEEPFILTERS('FACT-Data'[TEXT] <> BLANK())
)
RETURN
IF(ISBLANK(Total), 0, Total)

Another option is to add 0 at the end the formula:

TSF Facility in Use = CALCULATE(
COUNT('FACT-Data'[TEXT]),
KEEPFILTERS('FACT-Data'[TEXT] <> BLANK())
) + 0