Forum Discussion

Helper V

6 years ago

Solved

Using " IN " Function

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
6 years ago
HI unais

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

there is an IN operator

You can use like below:

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

v-lionel-msft
6 years ago
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.

3 Replies

az38
Community Champion
6 years ago
HI unais

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

there is an IN operator

Super User

You can use like below:

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

v-lionel-msft
Community Support
6 years ago
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.