Filter text 2 columns

[XaviOV]

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 rows that have the same ID (ID is random). I attachment a picture.

Regards,

Xavi

[Greg_Deckler · Accepted solution]

@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]

@XaviOV 

Could you try this

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

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

[XaviOV]

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]

@XaviOV  I had modified logic in the previous post.

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

[nandukrishnavs · Accepted solution]

@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 🙂

[nandukrishnavs]

@XaviOV 

Create a calculated column

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

Now you can filter this column.

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

[XaviOV]

Hi @nandukrishnavs and @Greg_Deckler 

Thanks for you reply, but I want to that ID of "Fundidores" and "Filtros Emulgente" in the rest of lines that same ID that "Fundidores" and "Filtros Emulgente". Attached image the result of what I want.

Regards,

Xavi

[Greg_Deckler]

@XaviOV OK, all the color stuff going on is not helping. You need to do this:

1. Post a sample of your source data as text. Use the table feature in the bar

2. Post what you want as output. Just the rows that correspond to the sample source data that you want in the output

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[XaviOV]

Hi @Greg_Deckler

Regards,

Xavi

Source data:

ID	Pregunta	Pestaña
AAARVDBU	HP	Valores-HP
AAARVDBU	Línea	DataKey1508409950520
AAARVDBU	Nombre	DataKey1519315817647
AAARVDBU	Hora
AAARVDBU	Fundidores	Valores-fundidores
AAARVDBU	Centrífuga	Valores-centrifuga
AAARVDBU	Semana
AAARVDBU	Trabajar fin de semana	DataKey1522249127825
AAARVDBU	Fecha
AAARVDBU	Año
AAARUDGI	Filtro Agua	Filtro-agua
AAARUDGI	Filtro Emulgente	Filtro-emulgente
AAARUDGI	Línea	DataKey1508409950520
AAARUDGI	Nombre	DataKey1519315817647
AAARUDGI	Filtro Emulgente	DataKey1567402334544
AAARUDGI	Limpieza completa Filtros Preparación	DataKey1517842778543
AAARUDGI	Hora
AAARUDGI	Semana
AAARUDGI	Fecha
AAARUDGI	Año
AAARUCFJ	Foto	Foto-cortado
AAARUCFJ	Filtros GAF	Residuos
AAARUCFJ	Línea	DataKey1508409950520
AAARUCFJ	Nombre	DataKey1519315817647
AAARUCFJ	Selección tanque GAF	DataKey1522244698903
AAARUCFJ	Nivel tanque Lipsa	DataKey1543398759149
AAARUCFJ	Caudal bomba	Caudal
AAARUCFJ	Toneladas filtradas	Toneladas
AAARUCFJ	Foto	Foto-lateral
AAARUCFJ	Foto	Foto-boca
AAARUCFJ	¿Hay cambio de filtro?	DataKey1519313871619
AAARUCFJ	Filtros GAF	Observaciones
AAARUCFJ	Filtros GAF	GAF
AAARUCFJ	Hora
AAARUCFJ	Semana
AAARUCFJ	Fecha
AAARUCFJ	Año	Output data: ID Pregunta Pestaña AAARVDBU HP Valores-HP AAARVDBU Línea DataKey1508409950520 AAARVDBU Nombre DataKey1519315817647 AAARVDBU Hora   AAARVDBU Fundidores Valores-fundidores AAARVDBU Centrífuga Valores-centrifuga AAARVDBU Semana   AAARVDBU Trabajar fin de semana DataKey1522249127825 AAARVDBU Fecha   AAARVDBU Año   AAARUDGI Filtro Agua Filtro-agua AAARUDGI Filtro Emulgente Filtro-emulgente AAARUDGI Línea DataKey1508409950520 AAARUDGI Nombre DataKey1519315817647 AAARUDGI Filtro Emulgente DataKey1567402334544 AAARUDGI Limpieza completa Filtros Preparación DataKey1517842778543 AAARUDGI Hora   AAARUDGI Semana   AAARUDGI Fecha   AAARUDGI Año

[Greg_Deckler · Accepted solution]

@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.

[Greg_Deckler]

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