How to exclude a value from a column based on BLANK in another column?

[JHarmon]

My hourly data shows 'blank' between 11:00PM and 12:00AM.  I'm trying to figure out a measure that would "skip" the circled value when the Time Slot is blank.  Unsuccesful so far.

Data with missing time:  Example.xlsx The hourly time is "60 minute time slot" in the file.  Sensor 5 has a value that I want to delete or skip as the chart is drawn.

[JHarmon]

The master timetable join is present, as is the master date table join.  The colum on the axis has a blank.  The visual filter did the trick!! Success and thank you!!

[amitchandak · Accepted solution]

@JHarmon , the Blank value can be because the master timetable is missing join or the column used on the axis has blank.

You can use a visual level filter and remove the blank value (Use is not blank)

or have measures like

calculate(sum(Table[Value]), not(isblank(Table[Column])) )