Forum Discussion
Filter data from table from two rows
- 7 years ago
hi, rschaudhr
For your case, you could add set the visual level filter for this table visual.
Set first column is "0" and last column is not blank.
Best Regards,
Lin
- 7 years ago
Unfortunately, it did not work. The reason is that if I set the filter to 0, the the values with non-blank disappear. In this case the filter has be be done in two different column.
- 7 years ago
hi, rschaudhr
If so, just create measure by OR logic as below:
New measure= IF( [first column expression] =0 || [last column expression] <>blank(),1,2)
Then drag this column into visual level filter directly and set it is "1"
Best Regards,
Lin
Unfortunately, it did not work. The reason is that if I set the filter to 0, the the values with non-blank disappear. In this case the filter has be be done in two different column.
hi, rschaudhr
If so, just create measure by OR logic as below:
New measure= IF( [first column expression] =0 || [last column expression] <>blank(),1,2)
Then drag this column into visual level filter directly and set it is "1"
Best Regards,
Lin