Forum Discussion
Coalesce replace Blank
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
2 Replies
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.
