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.
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?