Something like COUNT(IF [Your Measure] > 2.5 THEN 1 END) should work.
Thanks for your reply.
I have tried it but returns a zero (0). Any other idea maybe?
Are you sure you have values greater than 2.5 at the ROW LEVEL? And are you sure it is a numeric measure (ie. not text)?
Yes the value of the measure is greater than 2.5 and it is a numeric (Decimal).
Can you please provide a mock workbook? Should not take more than 5 minutes to create using superstore sales data source.
John, sorry the calculation field is working just had refresh the data.
Thanks for your assistance