Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
0
blank
coalesce
COUNT
distinctcount
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
5 years ago

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.