How to make a calculated field that will be true for each row if one row is true in Tableau?

Question

I have a data table with column Status and Extract Name and some other columns. I want to create a calculated field whose value will be true for each row if one row is true. To be clear, if there is a row where the Status is "In progress" and Extract Name is "A" I want the other rows for which this is not valid to be true (I mean that column Calculation should be true for each row), not just for that row. The picture shows that table where I was able to make only that row true.

This is the code:

IF [Status]="In Progress" AND [Extract Name]="A"
THEN TRUE
ELSE FALSE
END

How do I modify that code to get what I want, to make all rows true if there is one row that matches this condition?

AnilGoyal AnilGoyal · Accepted Answer · 2021-01-22T07:49:12

use this

IF
{MAX(IF [Status]="In Progress" AND [Extract Name]="A"
THEN 1
ELSE 0
END)} >0 THEN TRUE ELSE FALSE END

If you want a demonstration, please add some sample data

How to make a calculated field that will be true for each row if one row is true in Tableau?

2 Answers