Filter out entire row based on one result in Tableau

Question

Learning Tableau through tutorials so bear with me.

I have a list I need to filter, but when I set up a calculated field, it only filters out a single cell, not the whole row.

Here's the example I made:

1

In this table, I want to filter out entire rows that have negative values. Alice and Bob would be hidden, but Cat and Dee would remain.

When I add a (IF SCORE <0 THEN 0 ELSE 1 END) filter, I only filter out that single value, not the whole row. Example:

2

How do I write a calc to hide the rows with negatives?

Answer 1

Sorry i cannot recreate your example, but i used one of my use cases.

just drag "name" to the filter pane and in the filter options go to conditions

there you need to apply the logic of Value > 0

This will make the rows disappear. Hope this helps