Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
42 | |
39 | |
19 | |
19 |