Forum Discussion

gpiero's avatar
gpiero
Icon for Skilled Sharer rankSkilled Sharer
10 years ago
Solved

Using COUNTAX to check logical field

 

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

Need Help
  • gpiero's avatar
    gpiero
    10 years ago

    Sean

    thanks

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

     

2 Replies

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    10 years ago

    gpiero try this Measure

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

    • gpiero's avatar
      gpiero
      Icon for Skilled Sharer rankSkilled Sharer
      10 years ago

      Sean

      thanks

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