How to get a count of region by sales person

[kmcallister]

Hi there, 

I'm having trouble calculating the count of sales people per region.

My Data looks like this:

So in this example, when Jim goes to the dashboard, he should see that there are 3 total people in the west region. Tom would see that he only has 1 in the region., etc.. 

This becomes a bit of a challenge because we actually have about 250 regions with about 5-10 people sit inside of. 

Thanks,

Kevin

[v-yuezhe-msft · Accepted solution]

@kmcallister,

Create a measure using DAX below and check if you get expected result.

Measure  = CALCULATE(COUNTA(Table[Name]),ALL(Table[Name]))

Regards,
Lydia

[Anonymous]

H @kmcallister,

Try Calculate(DISTINCTCOUNT(table[Name]), groupby(table, table[Region])