Count()

[Former Member]

How to count the measure value in table for the value greater than 0.

Count=2

It should count the repetitive value as well.

Also how to take that count in an individual cell to for calculating percentage.

[Former Member · Accepted solution]

Create a dimension with  formula as

[New]= if [object]>0 then 1 else 0

And then take a sum of that in a separate cell

=  sum([New]) In Report

Regards

Niraj

[former_member198519]

Try:

[Count]=Count([Object];All) Where ([Object]>0)

[Former Member]

Thanks for the answer!

It does not work mind it the [Object] is a measure objects.

[former_member198519]

What is the result you are getting. Can you give us a screenshot of the same