Count If value of calculated measure is X

[Anonymous]

I have a calculated measure and would like to know how to get a count of ClientIDs that have a value greater than X after performing the calculated Measure

Calculated Measure formula that gives me a percentage number:

(Sum([Billable Case Hours])+Sum([Non Billable Case Hours])+Sum([Non Billable Case Hours(ASP)]))/(sum(Total Revenue)/500)

Would like to count the number of ClientIDs that are over 100% or 1.0 in the above measure formula.

This attempt is not working:

if(Sum([Billable Case Hours])+Sum([Non Billable Case Hours])+Sum([Non Billable Case Hours(ASP)])/(sum(Total)/500)>1,count([Client ID]))

[tamilarasu]

Hi David,

Sum(Aggr( If(Sum([Billable Case Hours])+Sum([Non Billable Case Hours])+Sum([Non Billable Case Hours(ASP)])/(sum(Total)/500)>1,1), [Client ID]))

Or

Count(Aggr( If(Sum([Billable Case Hours])+Sum([Non Billable Case Hours])+Sum([Non Billable Case Hours(ASP)])/(sum(Total)/500)>1,[Client ID]), [Client ID]))

[Anonymous]

Tamil, Thank you very much!

[tamilarasu]

Not a problem David. Have a nice day