Forum Discussion
Count and Inverse Count based on Parameter Range
EHP829 Here's an inverse aggregator and inverse selector that may help: Inverse Aggregator - Microsoft Fabric Community, Inverse Selector - Microsoft Fabric Community
Otherwise, Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
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?