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 Greg_Deckler

 

Regards,

 

Xavi

Source data:

IDPreguntaPestaña
AAARVDBUHPValores-HP
AAARVDBULíneaDataKey1508409950520
AAARVDBUNombreDataKey1519315817647
AAARVDBUHora 
AAARVDBUFundidoresValores-fundidores
AAARVDBUCentrífugaValores-centrifuga
AAARVDBUSemana 
AAARVDBUTrabajar fin de semanaDataKey1522249127825
AAARVDBUFecha 
AAARVDBUAño 
AAARUDGIFiltro AguaFiltro-agua
AAARUDGIFiltro EmulgenteFiltro-emulgente
AAARUDGILíneaDataKey1508409950520
AAARUDGINombreDataKey1519315817647
AAARUDGIFiltro EmulgenteDataKey1567402334544
AAARUDGILimpieza completa Filtros PreparaciónDataKey1517842778543
AAARUDGIHora 
AAARUDGISemana 
AAARUDGIFecha 
AAARUDGIAño 
AAARUCFJFotoFoto-cortado
AAARUCFJFiltros GAFResiduos
AAARUCFJLíneaDataKey1508409950520
AAARUCFJNombreDataKey1519315817647
AAARUCFJSelección tanque GAFDataKey1522244698903
AAARUCFJNivel tanque LipsaDataKey1543398759149
AAARUCFJCaudal bombaCaudal
AAARUCFJToneladas filtradasToneladas
AAARUCFJFotoFoto-lateral
AAARUCFJFotoFoto-boca
AAARUCFJ¿Hay cambio de filtro?DataKey1519313871619
AAARUCFJFiltros GAFObservaciones
AAARUCFJFiltros GAFGAF
AAARUCFJHora 
AAARUCFJSemana 
AAARUCFJFecha 
AAARUCFJAño 

 

Output data:

IDPreguntaPestaña
AAARVDBUHPValores-HP
AAARVDBULíneaDataKey1508409950520
AAARVDBUNombreDataKey1519315817647
AAARVDBUHora 
AAARVDBUFundidoresValores-fundidores
AAARVDBUCentrífugaValores-centrifuga
AAARVDBUSemana 
AAARVDBUTrabajar fin de semanaDataKey1522249127825
AAARVDBUFecha 
AAARVDBUAño 
AAARUDGIFiltro AguaFiltro-agua
AAARUDGIFiltro EmulgenteFiltro-emulgente
AAARUDGILíneaDataKey1508409950520
AAARUDGINombreDataKey1519315817647
AAARUDGIFiltro EmulgenteDataKey1567402334544
AAARUDGILimpieza completa Filtros PreparaciónDataKey1517842778543
AAARUDGIHora 
AAARUDGISemana 
AAARUDGIFecha 
AAARUDGIAño 
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
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.