topic Re: How to use Calcute Function to filter for 2 numbers in DAX Commands and Tips

How to use Calcute Function to filter for 2 numbers

e175429 — Wed, 12 Apr 2023 21:02:14 GMT

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

Re: How to use Calcute Function to filter for 2 numbers

FreemanZ — Wed, 12 Apr 2023 22:54:52 GMT

hi e175429

try like:

eROW =

calculate(

[total respondents],

OCE[Row] IN {9,7}

)

or

eROW =

calculate(

[total respondents],

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

)

Re: How to use Calcute Function to filter for 2 numbers

e175429 — Thu, 13 Apr 2023 16:30:20 GMT

Thank you FreemanZ

The second option worked

eROW =

calculate(

[total respondents],

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