Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

URGENT HELP needed: search for multiple values from different lists

I have two lists of keywords: Brand and Manufacturer. I have filters allowing to select multiple out of both lists. I need to find the (selected) keywords from (both) these lists in a table column T...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Yes, exactly, combine filters in an AND fashion.

So, if raisin AND allergy AND recall are selected, it shows exactly the text you have in your image, and which is now shown if only raisin but none of the Effect filters.

And true, if only raisin and no Effect filter is chosen, it already shows what I need.

I also forgot to mention that I was using CONTAINSEXACTSTRING as I really need to search for full words, also case-sensitive. But of course I can change this myself.

Thanks a lot!

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
So, if raisin AND allergy AND recall are selected, it shows exactly the text you have in your image, and which is now shown if only raisin but none of the Effect filters.

That is yet another rule that you didn't make clear.  So not only combine the categories but also demand that all selected values in a category are present?  You would need to replace SUMX with PRODUCTX.

 

if you want to use CONTAINSEXACTSTRING then you would have to map True() to 1 and False() to 0.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I was trying to specify right from the start that I need multiple selections and select all. 

    I'll see what's possible with PRODUCTX.

     

    Another issue is that even using your measure as developed (with or), it won't aggregate or even show all days correctly. In the picture below it shows only the 7th of Jan, nothing else. 

    This was also one of the issues I was initially writing about.

     

    I don' know why it won't let me attach the file (type .pbix not supported)!! I used drag&drop, is there another method? I just added a Date Hierarchy.

    Many thanks anyways!