minimum distance of a customer then aggregated to show how many customers fall in each bucket

[pbi_user_47]

first timer. I am trying to do what feels like a simple aggregation. I have a list of customers and their distance to candy stores. I want to summarize the number of customers by their distance to the closest store. 

in SQL it looks like this: 

select

  closest_store

  ,COUNT(DISTINCT customerID) AS customers

from (select

        customerID,

        min(dist_miles_bins) as closest_store

      from table1

      where

        store_item_type = 'CANDY'

        and store_name IN ('candystore','sugarrush')

      group by all

    ) a

 group by all

 order by closest_store

My problem is that when I go to plot this in a clustered bar graph I cannot get the axis to show the closest_store on the x-axis and the distinct count of customers on the Y-axis. please help and show me how I am missing a simple one line solution. thank you.

[MarkLaf · Accepted solution]

A measure solution.

Cust Count by Min Miles = 
VAR _milesInFilterContext = VALUES( Table1[Miles Away] )
RETURN
COUNTX( 
    VALUES( Table1[customerID] ), 
    VAR _minMileByCust = CALCULATE( MIN( Table1[Miles Away] ), ALL( Table1[Miles Away] ) )
    RETURN
    IF( _minMileByCust IN _milesInFilterContext, 0 )
)

Formatting: continuous x-axis with title/value labels off + custom format data labels

[pbi_user_47]

YEP. SAVED MY WEEKEND. TYFYS MARK.