Filter data from table from two rows

[rschaudhr]

I have a table visualization and there are companies listed and the first row shows 0 under some columns. So, I want to filter out that row the rows and column that have 0s. Then I want to go to the last column which is blank for the most part, but when it show the value, I want to pull that data in that column and also show some other columns associated with it. This two sets of rows should merge as one row in the end. 

The screen shot is shown

I hope this is enough information. Thank you!

[v-lili6-msft · Accepted solution]

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

[rschaudhr · Accepted solution]

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.

[v-lili6-msft · Accepted solution]

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

[rschaudhr · Accepted solution]

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.

[v-lili6-msft · Accepted solution]

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