Forum Discussion
Helper VReplacing blank value in card visual
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?
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
3 Replies
You can create meaure and Return the measure value + 0 for eg = > Return Countrows(Table1) + 0
TechR21Im 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
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