Count should return 0 instead of (Blank)

[stephanv]

Count of should return 0 instead of '(Blank)' (looks better on a Dashboard)

[pat527]

THIS IS URGENT PLEASE!

[JonnyH]

Yep adding 0 at the end of the measure worked @craig

[fbcideas_migusr]

That could be a option by Element. Some visuals don't need this option and additionnal Zero could be just noise but on some visuals, turning on this option could be a great way to get niciest results.

[george_mena_s]

I agree having the zero makes the visuals look more elegant. Blank is go to know there is an error, but that doesn't make sense for a visual.

[vishalbhanderi]

Quick work around if anyone is interested. Adding a zero forces Power BI to display Zero! CALCULATE(COUNTROWS(table),table[column]) + 0

[melissa_lord]

Adding a zero on the measure worked, great workaround.

[thomas_laresch1]

DAX returning blank makes sense because of what it means in the context of charts. If there is no data for a particular dimension, then generally we do not want it to draw a line or a bar. However, in the case of cards, I believe the default behavior would be best if it showed zero instead of (Blank). Given that (Blank) is the established behavior, I would ask that a formatting option be created for card and multi-card to show 0 instead of blank.

[hasan_arslan]

Adding + 0 to your formula should take care of the blank

[davidcadman]

It makes sense that Blank is returned by formulas sometimes, but on say the Card visual it would make sense to have the option "Display (Blank) as 0" Y/N

[pat527]

Adding a 0 is fine, but it's not always a solution. Not in all cases. I agree with David Cadman, an option to choose how to display (Blank). Sometimes 0 is alright, something plain text saying "None". Anything but (Blank).