Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Hello @Anonymous
You can try this code.
Cases = DISTINCTCOUNT(DD_FLU_DEMOGRAPHIC[Case ID]) + 0
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.
User | Count |
---|---|
57 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |