KPI with 2 criteria and one is a sum

[SMiller_FL]

I want to count all [Primary Care Managers] who have a case load greater than 90. There is a [countall] field that already has a 1 in each row  that I could use to count. I also need to filter on the column [Tier-TierNum] and select just those that are '3'. 

I have tried the following and I am not getting the correct answer. Any help in correcting my syntax would be appreciated as always!

Count({<[Primary Care Manager Name]={"=count([countall])>90"}, [Tier-TierNum]={'3'}>} distinct [Primary Care Manager Name])

=count(distinct aggr(if(count(distinct [Primary Care Manager Name])>"90",[Tier-TierNum]={"3"}),[Primary Care Manager Name]))

[vinieme12]

Does the field TierNum. relate to Manager Name or the Cases??

If TierNum relates to Cases then try below

=Count({<

[Primary Care Manager Name]={"=count({<[Tier-TierNum]={'3'}>} [countall])>90"}

>} distinct [Primary Care Manager Name])

[rubenmarin · Accepted solution]

Hi, can you try with?:

Count({<[Primary Care Manager Name]={"=sum({<[Tier-TierNum]={'3'}>}[countall])>90"}>} distinct [Primary Care Manager Name])

[SMiller_FL]

Thanks!!! I keep getting the syntax terribly  out of order.