How to use Calcute Function to filter for 2 numbers

[e175429]

Hi All,

What is the correct way to filter a column for 2 numbers?

I want to filter so that i get a total number of selection for 9 and 7

So far I have:

eROW = calculate([total respondents], OCE[Row] = "9,7")

wich obviously is not correct.

Then I thought it would be:

eROW = calculate([total respondents], OCE[Row] = "9" and "7")

but that's not right either

[e175429]

Thank you @FreemanZ 

The second option worked 

eROW =

calculate(

[total respondents],

OCE[Row] IN {"9","7"}

[FreemanZ · Accepted solution]

hi @e175429 

try like:

eROW = 

calculate(

    [total respondents], 

    OCE[Row] IN {9,7}

)

or

eROW =

calculate(

[total respondents],

OCE[Row] IN {"9","7"}

)