Countrows with Column A string and B number

[a10703]

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 A is = "NACIONAL" and if the value on column b ="0" or "1" .

But my measure appears one error "MdxScript(Model) (121, 167) Calculation error in measure "Table1"[feedbackmeasure]: Function 'CONTAINSROW' does not support comparison values ​​of type Text with values ​​of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.

My measure:

feedbackmeasure= calculate(counta('Table1'[COLUMN A]),Filter(Table1,Table1[COLUMN A]="NACIONAL" && Table1[COLUMN B] IN {"0","1"} ))

Datatable:

COLUMN A	COLUMN B
NACIONAL	1
INTERNACIONAL	3
NACIONAL	4
NACIONAL	4
NACIONAL	1
INTERNACIONAL	3
INTERNACIONAL	3
NACIONAL	0
NACIONAL	1
NACIONAL	0
INTERNACIONAL	3
INTERNACIONAL	3

Some solution for this?

Thanks

[AntonioM · Accepted solution]

"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