User Profile
longlongisi
Frequent Visitor
Joined 2 years ago
User Widgets
Contributions
how to show CONCATENATE information if i just search part of the content using text search
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? Thanksvisual filter with measure not working
hi, i have added a measure filter to the Table visual. I would like not to display the values of table visual if the slicer is not selected. filtercheck = INT(isfiltered('Product'[BCP])). However, it doesn't work. I do add a card to test the measure , it works properly. Can anyone help?
