Help with Pivot Tabelle

[Manuel174102]

Hello People!

I need to show in a Pivot Tabelle the quantity of orders where the commision was 0.

How could I do it? I know that I would need a measure but I do not know how make the formula right.

The orders are named "VR" and the commision number is " Commision_"

I tried with if([Commission_]='0',count(VR)) but it doesnt work.

Greetings

[brunobertels]

hi 

try with set analysis : 

Count({<[Commission_]={'0'}  >} VR ) 

[Manuel174102]

hello, it does not work. It is counting also the one which commision is higher than 0 😞

[Timario]

hi.

try next expression:

sum( if([Commission_]='0' or  [Commission_]=0  , 1 ,0 )  )
Maybe your Commission_ is not text

[SunilChauhan]

Can you Please check include zero check box as in screen shot

include Zero Value

and hope fully this expression

count(if([Commission_]='0',VR))

or 

Count({<[Commission_]={'0'}>}VR)

or 

Count({<[Commission_]={0}>}VR)