Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]))
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]))
Tamil, Thank you very much!
Not a problem David. Have a nice day