Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Countrows with Column A string and B number

Hi guys, I need help in one measure.   I have the format Column A = String and the Collumn B = Number I need to count the number of rows that meet these requirments: Count if the value on column...
Need Help
  • AntonioM's avatar
    AntonioM
    4 years ago

    "0" and "1" are both Text, because you've enclosed them in quotes. 

     

    Try 

    Table1[COLUMN B] IN {0,1}

    and see if that works

AntonioM's avatar
AntonioM
Solution Sage
4 years ago

"0" and "1" are both Text, because you've enclosed them in quotes. 

 

Try 

Table1[COLUMN B] IN {0,1}

and see if that works