3 Replies Latest reply on Jun 19, 2018 7:19 AM by Charles Wang

    Count row based on values in 2+ columns (countif?)

    Charles Wang

      Hi all,

       

      Please see my mock data below. I am trying to count every row/ID in a dataset for which there is a value of 1 in Indicator 1 and Indicator 2. If there is a 0 in either indicator column, I do not want to count that row.

         

      IDIndicator 1Indicator 2
      55511
      55211
      10610
      13601
      63201
      75411

       

      I understand how to do it in Excel but the data has so many rows that I must use Tableau. I am not sure if there is an equivalent function to use here.

       

      Much thanks in advance!