Have Count Card show zero instead of (blank)

[Bizo]

Hi,

I have multiple count cards on my dashboard that are filtering for 'New' items.  I am currently using conditional formatting that changes the color to the background if there are no values butmy director wants the card to show zero instead.  Since it's not a calculated value or sum as I've seen other DAX calculations solve, is there a way for the count card to show zero if there is no data?

[barritown · Accepted solution]

I guess something like:

Measure = COALESCE ( COUNT ( 'Your Table'[Title] ), 0 )

You should put it to your visual instead of 'Count of Title'.

[Bizo]

That worked I think, thanks!

[barritown]

Great. 

BTW, there is also another option to achieve this: 

Measure = COUNT ( 'Your Table'[Title] ) + 0

[barritown]

Hi,

I'd advise you to check documentation on COALESCE. Here's the link - https://learn.microsoft.com/en-US/sql/t-sql/language-elements/coalesce-transact-sql?view=sql-server-...

Your measure will look like:

Measure = COALESCE ( <your calculation>, 0 )

[Bizo]

Thank you for the response but unsure what to put in <your calculation>.  So I haven't created any measures.

I basically have a card where I'm using 'Count of Title' and filtering for Category = 'Newly Identified'.  When there are no Titles with a 'Newly Identified' as the category it's showing as (blank) when I want it to show zero.