Is there a way to get a status field used in a filter to show 0 on a card instead of blank?

[EaglesTony]

Hi,

  I have the following table:

TableA:

Key

Status (which can be In Progress, Done, etc)

The issue is that when I map the Status field to a Card, use the Count on this fieldAND filter on the Status value it shows blank instead of 0.

Thus, if In Progress on a Card has 20 items, it shows correctly for that Card, I have a 2nd Card that is filtered down to Done, but there are no records, thus showing "Blank" and I need it to show 0.

[EaglesTony]

Wow...I overthought it...thanks!

[zenisekd · Accepted solution]

Hi @EaglesTony 

Create a simple measure that will be = COUNT(TableA[Status[) +0 

+0 will cause the calculation to work fine.