Replacing (Blank) with 0 on Cards

[TabathaN]

I've been reading other messages regarding this same topic however I haven't found one that matches my scenario. I am looking for a way to replace the (Blank) result with a zero on my cards when the filter criteria results in no data to be reported. Other messages were solved by putting +0 at the end of their calculate measure but my DAX does not include calculate.

Encounters Table

Scenario:

I want to know how many encounters are over 30 days old. I've created a calculated column that returns a 0(false) or 1(true) value.

Encounter Older Than 30 Days? = IF ( Encounters[Encounter Date] > ( TODAY () - 30 ), "0", "1" )

The card works as anticipated until I drill down and apply visual level filters. More specifically, my issue occurs when I'm filtering by "Encounter status" = Open, Review or Pend and "Assigned to" = jzechmann

Jzechmann does not have any records in an open, review or pend status so I would like the card to reflect 0 rather than blank.

I'm sure this must be possible, what do I need to do and/or change to make this work?

[v-danhe-msft]

Hi @TabathaN,

It seemed that you could use the isblank function to filter your data firstly. Due to I could not reproduce your problem with below condition:

Spoiler

when I'm filtering by "Encounter status" = Open, Review or Pend and "Assigned to" = jzechmann

Could you please share a sample file to have a test if possible?

Regards,

Daniel He

[luisenpons]

As there are no rows matching your condition, it shows blank. In the calculation of your card, you must specify something like IF(EMPTY(filteredtable);"0")

If you provide more info about your visuals, we will be able to help you better.

[AlB]

Hi @TabathaN

What are you placing exactly on the card? Is it your calculated column with some sort of summarization (count, etc.) ?