Card displays Blank, when value is not in filtered set

[Anonymous]

Hi folks,

     New user question...  I have a column with Red, Yellow, Green status options.  I filtered my dataset by a Service Category, each Service Category has a set of projects with  status options.  Some are empty, and in some cases, a Service Category only has one or a few of Green, or Green and Yellow projects.  I'm showing a card for each of the Values: Red card, Yellow Card, Green card.  If there are no entries for a given color, the Card is showing (Blank).  I'd like it to just show a 0.   Is there an easy way to just set the value to 0 if the response, for example:  Red, doesn't appear in the results for that Category?

[Anonymous]

This doesn't change a thing.  The initial data set doesn't have any 'red', so it's a case of the data not being in the data set.  When I try to filter on it, I want a 0 instead of a blank, but it's not even in the data set, so the above doesn't work.  How can I insert a 0 when the result of the filter doesn't exist?  This can change at any time, so I want the dashboard to be able to refresh and pick up a 'red' if it occurs.

[v-kkf-msft]

Hi @Anonymous ,

I am not sure if I understood your question correctly. Do you want all cells that show "(Blank)" to show "0"?

Then add 0 to your value, like this.

Measure = SUM('Table'[values]) + 0

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Where else can someone go for help with these issues?  Noone seems to be interested here

[Anonymous]

example: