Forum Discussion
How to exclude a value from a column based on BLANK in another column?
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 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])) )
2 Replies
- amitchandak
Super User
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])) )
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!!
