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.



      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!