Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Search String for Multiple Keyword...

Hi all!!   I am new in PBI and I have some question about a search function. I hope someone could help me.   I have a column with Keywords and I use them as a filter slicer    I want to select ...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous,

Please use DAX below, then set value of chkmeasure in visual level filter to 1.

chkmeasure = IF(
      SUMX(Keys,
           FIND(
                UPPER(Keys[Column1]),
                UPPER(MAX(Mytable[MAT_DESCRIPTION]))
                ,,0
               )
          ) > 0,
      1,
      0
     )




More details in this PBIX file.

Regards,
Lydia

gco's avatar
gco
Resolver II
6 years ago

Thanks Anonymous , your measure helped me with one of my reports.