Forum Discussion

rschaudhr's avatar
rschaudhr
Icon for Resolver II rankResolver II
7 years ago
Solved

Filter data from table from two rows

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 ...
  • v-lili6-msft's avatar
    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

  • rschaudhr's avatar
    rschaudhr
    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.

  • v-lili6-msft's avatar
    v-lili6-msft
    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