Forum Discussion

XaviOV's avatar
XaviOV
Icon for Helper V rankHelper V
6 years ago
Solved

Filter text 2 columns

Hi!   I have a table with differents columns. I want to filter by data of column "Pregunta", for example "Fundidores" or "Filtro Emulgente", and with theese filter I want to save the data of the r...
DAX
Filter
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    XaviOV OK, the code I provided earlier seems like it is doing exactly what you are asking or else I am missing something. See attached PBIX file.

     

  • nandukrishnavs's avatar
    nandukrishnavs
    6 years ago

    XaviOV  

     

    FilterColumn =
VAR _id =
    SUMMARIZE (
        FILTER ( 'Table', 'Table'[Pregunta] IN { "Fundidores", "Filtro Emulgente" } ),
        'Table'[ID]
    )
VAR _result =
    IF ( 'Table'[ID] IN  _id , "Show", "Hide" )
RETURN
    _result

    This should work.



    Did I answer your question? Mark my post as a solution!
    Appreciate with a kudos     🙂

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Perhaps:

 

New Table =
  VAR __IDs =
    SELECTCOLUMNS(
      FILTER('Table',[Pregunta] = "Fundidores" || [Pregunta] = "Filtro Emulgente"),
      "ID",
      [ID]
    )
  VAR __Table = 
    FILTER('Table','Table'[ID] IN __IDs)
RETURN
  __Table