how to show CONCATENATE information if i just search part of the content using text search

[longlongisi]

Hi All,

I have the data table as below

i can concatnate the rows as below using measure 

RECIPECOMBINEDHOR = CONCATENATEX('Component_Ingredients','Component_Ingredients'[INNGREDIENTPERCENTAGE],", ")

However, when i use the Text search visual, for example, i search " chicken breast", only the rows contain " Chicken Breast" are shown, how can i search the text and show the whole recipe ( concatnated recipe in 2nd table above) contains the search text?

Thanks

[MohamedFowzan1]

It should be straight forward to add the concatenated field into the custom visual "Text Filter" or "Text Search Slicer" and type in any key word.

Hope this helps!

[v-yangliu-msft · Accepted solution]

Hi  @longlongisi ,

You could try changing the measure [RECIPECOMBINEDHOR] to place [INNGREDIENTPERCENTAGE] in the visual

Here are the steps you can follow：

1. Create measure.

RECIPECOMBINEDHOR =
CONCATENATEX (
    FILTER (
        ALL ( 'Component_Ingredients' ),
        'Component_Ingredients'[BCP] = MAX ( 'Component_Ingredients'[BCP] )
            && 'Component_Ingredients'[Component Unique Code]
                = MAX ( 'Component_Ingredients'[Component Unique Code] )
    ),
    'Component_Ingredients'[INNGREDIENTPERCENTAGE],
    ","
)

2. Result:

Best Regards,

Liu Yang

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

[longlongisi]

hi @v-yangliu-msft ,

In fact, i am very new to Power BI, thanks for your solution, but actually i dont understand the logic inside Filter, if you dont mind, is it possible to further explain to me the reason of using Max?

[longlongisi]

Thanks Sooooooo Much, it works.😁