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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks very much for your help!

     

    I only have a doubt, when i select the option select all, dont send me results.

     

    Thanks.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Anonymous,

      I am afraid that Select all option will not work in this case. I would recommend you disable select all option as it has same effect as that there is no selection in the slicer.

      Regards,
      Lydia

  • gco's avatar
    gco
    Resolver II
    6 years ago

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