Forum Discussion
Solved
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 missi...
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])) )
amitchandak
Super User
Super UserJHarmon , 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])) )