Using COUNTAX to check logical field

[gpiero]

Hi,

I 'am trying to count how many rows in MyTable have MyField = Y.

MyField is a logical field.

But something goes wrong...

How can I solve the counting in MyField?

IDCLosed = COUNTAX('Mytable'; [MyField] = TRUE())

Thanks

[Sean]

@gpiero try this Measure

IDClosed = COUNTROWS ( FILTER (Table, Table[MyField]="Y") )

[gpiero · Accepted solution]

@Sean

thanks

It works. I had to substitute  = "Y"))  with  = true ))