Count of drivers per geofence

[Andrew_na_lang]

Hi Fam,

I need assistance. 

I have a table where it tells me the name of the drivers and their assigned geofences. 
How could I turn this table to just show the number of drivers per geofence? 

Eventually, I need to compute the average number of orders per driver in their specific geofences.

Your help is much appreciated.

[rsbin · Accepted solution]

@Andrew_na_lang ,

Create a new Measure:

Drivers_Count = DISTINCTCOUNT( YourTable[name] )

In a Table Visual bring in geofence and add this new Measure.

If you have a small number of geofences, even a column or bar chart visual may work.  Just bring in geofence as an axis and this new Measure as the Value.

Good Luck and Regards,