Coalesce replace Blank

[Anonymous]

For showing the count which replaces the Blank to 0 at the cart, I have been using the following dax query:

Cases =
var caseCount = DISTINCTCOUNT(DD_FLU_DEMOGRAPHIC[Case ID])
return
IF(ISBLANK(caseCount), 0, caseCount)

But the problem is it rounds up the count. For example, it shows 38560 as 40K.
Would you please suggest any alternative?
I tried with coalesce function but it does not work for the string type data (for example, Case ID )

Regards

[Anonymous]

Hello @Anonymous 
You can try this code.
Cases = DISTINCTCOUNT(DD_FLU_DEMOGRAPHIC[Case ID]) + 0

[AlexisOlson]

Both possible branches of IF need to return the same data type. In your case, they're both numeric. Fortunately, you can set the format for a measure if you don't like what it automatically chose for you.

If you had a string Case ID instead of a numerical count, then you'd need to use a string as the other option in the IF. For example, you could use "0" instead of 0.