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

6 years ago

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.

Super User

6 years ago

You can use like below:

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