Counting non-blank values of a measure with date slicer

[Anonymous]

I have a measure (Downtime) that takes many values from many tables and calculates something. The final result is a number.

When I plot this number against a date axis (like on a column chart) some values are blank - this is fine.

I want to find out the number of days that this measure was a blank. There is a date slicer on the page of this visual. Please help! Thanks!

[BA_Pete]

Hi @Anonymous ,

Would a measure like this work for you?

_blankDays =
CALCULATE(
  COUNT(aTable[Date]),
  ISBLANK([downtimeMeasure])
)

Pete

[Anonymous · Accepted solution]

Just tried it - it gives 7 as a result for the above example - should return 2 😞

[BA_Pete]

@Anonymous ,

Are you using a related calendar table for your chart axis? If so, try something like this:

_blankDays =
CALCULATE(
  COUNT(Calendar[Date]),
  FILTER(
    Calendar,
    ISBLANK([downtimeMeasure])
    || [downtimeMeasure] = 0
  )
)

Pete