0 votes
1 view
in BI by (13.4k points)

I have a simple COUNTIF task in Excel that is proving rather difficult to replicate in Tableau...

This is the data:

ID   Metric   Scope   DynamicCalc

1    A1       TRUE    X

1    B1       FALSE   X

2    B1       TRUE    X

2    A1       FALSE   X

2    C1       FALSE   X

The column 'DynamicCalc' should have the following values when Metric=A1 is selected: TRUE,TRUE,FALSE,FALSE,FALSE but if say B1 is selected it would be FALSE,FALSE,TRUE,TRUE,TRUE... so basically I want to assign a value of TRUE to the DynamicColumn if there is at least one TRUE in the Scope column to all rows for that ID. 

Please log in or register to answer this question.