Count Of employee Over date

[bilalkhokar73]

I have one user table 
I need thsi supervisor hwo many employee so I created this measure

#CountSR= CALCULATE(DISTINCTCOUNT(User[SR_ID])
When I am putting date in column from date table Then I am nto getting count
If that supervisor has 30 Salesman then I need all date 30,30,30 to shwo liek that  

Supervisor	01-Aug	02-Aug	03-Aug	04-Aug
Sup-A	30 staff	30	30	30
Sup-B	20	20	20	20
Sup-C	40	40	40	40

[ryan_mayu · Accepted solution]

@bilalkhokar73 

maybe try

#CountSR= CALCULATE(DISTINCTCOUNT(User[SR_ID]),allexcept(User(supervisor),date(date))