Count should return 0 instead of (Blank)

[stephanv]

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

[veijo_harkonen]

Count functions (all of them ) should return 0 (zero) value instead of in current use cases where is shown if there are no rows containing counted items. I consider this as a bug since all other numbers are shown ok in count functions.. except 0 (zero).

[John_Huynh1]

Since it happens so frequently with the Card visual, this would be nice as an option, rather than polluting the model with a measure just to show 0 instead of blank.

[chris150]

Unfortunately, you're very short-sighted, perhaps resulting from too much developer and not enough business insight. While coalesce may work, unless I'm mistaken, it doesn't work when the dataset returns all zeros. When used for drill-through purposes, BLANK still returns when coalesce is used...unless I'm using it incorrectly.

More attention should be paid to the numerous user requests rather than developer opinion. We know our businesses and use cases better, theoretically anyway.

[ben_mcmaster1]

Agree with Chris. We're trying to give a toggle box in Card options to show a 0 instead of blank - what if we don't want to have to band-aid this with a measure? I've got filters on the card instead.

[nishalit]

You can do this with the COALESCE function: https://docs.microsoft.com/en-us/dax/coalesce-function-dax. For example:

= COALESCE(SUM(FactInternetSales[SalesAmount]), 0)