Count Rows <25

[kari1282]

Hi I'm looking to figure out how the numbe of timekeepers with less than 25 hours.  M

Count <25 Pro Bono Hours = CALCULATE(DISTINCTCOUNT(WFE[Fee Earner Name]), FILTER(Utilisation, [Pro Bono]<25))

Just of note the Timekepeer and Pro Bono hours sit on two different tables.  The asnwer should be 5 but I'm getting 11 which is just a count of all timekeepers. 

Timekeeper	Pro Bono
a	0.3
b	1.8
c	125
d	55
e	22
f	92
g	21.6
h	21.7
i	22.6
j	73
k	133

[DataZoe]

Actually @kari1282 I think the issue is you need to FILTER the WFE table, not the Utilisation table. You would want to calculate the [Pro Bono] sum by Fee Earner Name, not filter just if they have at least one ROW in the Utilisation table that is less than 25.

Count <25 Pro Bono Hours on WFE = CALCULATE(DISTINCTCOUNT(WFE[Fee Earner Name]), FILTER(WFE, [Pro Bono]<25))

[DataZoe]

Hi @kari1282,

What is the relationship between the two tables?