Forum Discussion
Count and Inverse Count based on Parameter Range
I've read through the inverse aggregator articles and the common issues and couldn't find anything to help me understand why my measures aren't working.
If I have a list of people and their zip codes (fake in this example) and a list of stores and their zip codes
| ID | Zip |
| A | '00001 |
B | '00009 |
| C | '00003 |
| D | '00009 |
| E | '00001 |
| Stores | Zip |
| M | '00005 |
| N | '00006 |
| O | '00001 |
| P | '00005 |
I already have a measure that calculates the minimum distance between an individual and any of the stores in the list. The store lists and employee lists are very large so a calculated column needs to be avoided.
I have a radius flag measure that determines if an individual's minimum distance between themselves and any store is less than the dynamic range (see previous photos).
If, for the sake of this example, the range is set to 2 miles, (and we assume the distance between any of those fake zip codes is given by the difference in the last digit), I'd expect the following result:
| Number of People Within Range | Number of People Out of Range |
| 3 | 2 |
where persons A, C, and E were within range and persons B and D were outside the range.
Does this provide enough information to describe my scenario?