
1. Re: Help with calculation to find how many people satisfy the criteria of 2 measures
Luciano Vasconcelos Oct 7, 2016 4:56 AM (in response to Bruce Richardson)Post same data please.

2. Re: Help with calculation to find how many people satisfy the criteria of 2 measures
Ben Neville Oct 7, 2016 5:35 AM (in response to Bruce Richardson)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
Andrew Watson Oct 7, 2016 6:08 AM (in response to Bruce Richardson)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.