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

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!

• ###### 2. Re: Help with calculation to find how many people satisfy the criteria of 2 measures

As Luciano said, this may be a time where we need sample data to see what you mean.

It seems like the key is how this max is calculated. If you can calculate this on an LoD expression, this becomes something which is not an aggregate expression, and thus something you could put into the the web entries (or another "master") calculation. Something like:

Max Web Entry

{FIXED [Competition]: MAX([Entries])}

Master Calc

COUNTD(IF [Web Entries] = 1 AND [Entries] = [Max Web Entry] THEN [Mobile Number] END)

But I'm just guessing without being able to see real/mocked up data.

• ###### 3. Re: Help with calculation to find how many people satisfy the criteria of 2 measures

Interesting and as the others have said without data it's hard to understand this request. On the one hand you have a calculation that is only counting those numbers with 1 web entry and on the other hand you want to find how many of those had the maximum number of entries. Logically if the maximum is more than 1 then none of the numbers will appear in the first calc as it is restricted to those with only 1. Conversely if the maximum entries is 1 then all of them appear in the first calculation.

Some key information is missing here, providing some sample data should make things clearer.