Count If Dimension equal to

[saminouari]

Hi,

I want to count values >=1 of column "C" excluding zero values. For example : The total values of column "C" is 9, but what I want to do is to count values>=1 which give me a result of 6.

I tried different scripts such as : Count(If({'TV OLED'} Display>=1,1,null()))

[bharathadde]

Try this 

=Count({<Display={">0"}>}Display)

[saminouari · Accepted solution]

@bharathadde I find a solution Count(DISTINCT(if(Display> 0,Store)))