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     🙂

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

Hi nandukrishnavs 

When I'm doing you formula, under the formula appear this message
"A table of multiple values was supplied where a single value was expected."

Regards,

 

Xavi

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

XaviOV  I had modified logic in the previous post.

 

IF('Table'[ID]IN _id,"Yes","No")

 

  • nandukrishnavs's avatar
    nandukrishnavs
    Icon for Community Champion rankCommunity Champion
    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     🙂