Using " IN " Function

[unais]

Dears ,

I had to specfiy Multiple Values With Filter function with OR , instead OR function Like in SQL can be user " IN " function please advise.

[az38 · Accepted solution]

HI @unais 

look at manual https://docs.microsoft.com/en-us/dax/in-function

there is an IN operator

[Tahreem24 · Accepted solution]

You can use like below:

CALCULATE(
DISTINCTCOUNT('FactSales'[Sales ID]),
	FILTER('dimSales',[Status] IN { "Opened ","Closed" })
)

[v-lionel-msft · Accepted solution]

Hi @unais ,

About the use of IN, this document is very detailed.

IN operate .

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tahreem24 · Accepted solution]

You can use like below:

CALCULATE(
DISTINCTCOUNT('FactSales'[Sales ID]),
	FILTER('dimSales',[Status] IN { "Opened ","Closed" })
)

[az38 · Accepted solution]

HI @unais 

look at manual https://docs.microsoft.com/en-us/dax/in-function

there is an IN operator