Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Using PATHCONTAINS and SELECTEDVALUE

Hi, I have an items table, and a product table. In the product table I have a column where all the items required to build the product is listed in A_B_C fashion. I have created a ...
Need Help
Show and Tell
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Anonymous 

     

    You can try the following methods.

    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.

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, Anonymous 

 

You can try the following methods.

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.

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks for that !
    Just wondering will it be possible to let the user choose the ItemName, instead of ItemID ?
    Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    +Also wondering if I want to create a measure out of the Products, how do I apply this Item filtering ?