3 Replies Latest reply on Oct 7, 2016 6:08 AM by Andrew Watson

    Help with calculation to find how many people satisfy the criteria of 2 measures

    Bruce Richardson

      I have the below two measures with the following calculations.

       

      1. UNIQUE WEB ENTRIES

      COUNTD(IF [Web Entries] =1 THEN [Mobile Number] END) - this calculates the amount of unique entries into an online competition by mobile phone number.

       

      2. MAX WEB ENTRY

      MAX([Web entries per Number]) - this calculates the maximum online entries

       

      What I need to do is find how many of those unique entrants (measure 1), entered the maximum amount of times?

       

      I guess i need to do a COUNTD of those that satisfy both criteria but unsure how to do that.

       

      Any help appreciated!