'COUNTIF in Tableau?

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.

functiontableau-apitable-functionslevel-of-detailjavascriptcssreactjsimportsass


Solution 1:[1]

The LOD Expression can be used to retrieve your desired result try using a calculated field like below : 

{FIXED [ID],[Metric]:MAX(if [Scope]='TRUE' then 'True' else 'False' end)}

When the Selection is B1 :

enter image description here

Solution 2:[2]

I know this is late, but as SO community (bot) has made it active again, I propose a slightly different approach. The selection should be through parameter.

After making parameter on Metric field, create a calculated field say Dynamic calc like this

{FIXED ID : MAX({FIXED ID, [Metric]: MAX(If [Metric] = [Metric Parameter] THEN [Scope] END)})}

Add this field and your desired view is complete. See GIF below

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 vhadalgi
Solution 2 AnilGoyal

Related Questions