Replacing blank value in card visual

[TechR21]

Hi,

Im using a card visual to see the total numbers of a particular column. In the field of the visual Im using a simple count of id's, then I use a filter on the visual, based on the status of the id.

These numbers will change each week, so Im using the same filters, but when there is no number to shown (meaning no records will make it through the filtering in that week, I see a blank value.

How can I resolve this so that a "0" wil show instead for these columns when needed?

[RashmiP]

You can create meaure and Return the measure value + 0 for eg = > Return Countrows(Table1) + 0

[TechR21]

Im not sure how to use this measure then.. I cant use it as a filter, and it doesnt count the number of the column that I want

[RashmiP · Accepted solution]

In your questions you mentioned , " In the field of the visual Im using a simple count of id's", so create measure for that measure = Count(ID) + 0 , and use that in Card visual, so when there is blank vlaues, it will 0 instead of blank