Search for user selected "multiple" value in dataset

[Saniat]

Hi,

I am using the following method to create a filter in my dataset which filters my dataset for user selected value.

Is there any way to accept multiple user inputs ?

The sample dat a structure attached below.

Many thanks.

Measure = 
Var _N1=SEARCH(SELECTEDVALUE('Item'[ItemID]),SELECTEDVALUE('Product'[Items]),1,0)
Return
IF(_N1>0,1,0)

Put measure in the filter of this view and set it equal to 1.

[Ritaf1983 · Accepted solution]

Hi @Saniat 
You can use concatenatex function, please follow my example:

Link to the sample file: Here 
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly