5 Replies Latest reply on Oct 14, 2019 12:37 PM by Norbert Maijoor

    Counting unique rows with a condition

    Ahsan Usmani

      Hi - I am new to tableau. I am working on below data (tableau file attached). I want to count the number. of product (Kenwood, Whirlpool etc.) after removing unique Record No. So for example Kenwood has a count of 6 and Hitachi has a count of 1 (after removing unique Record no.) etc. I want to show count of all the products on one sheet. I have tried many different things but nothing seems to work.

       

      Count(Kenwood) returns 8 (it includes duplicate records). I also tried {fixed [Record No]: count([Kenwood])} but it also returns 8.

       

      Any help will be much appreciated.

       

        

      Record NoKenwoodWhirlpoolSamsungHitachi
      4777226 YesYes
      4777227YesYesYes
      4777228YesYes
      4777228YesYesYes
      4777229 YesYes
      4777230 YesYes
      4777230YesYesYes
      4777230YesYes
      4777231 Yes
      4777232YesYes
      4777233YesYes
      4777234YesYes Yes
      4777234 YesYesYes
      4777235 YesYes