topic Re: Filter text 2 columns in DAX Commands and Tips

Filter text 2 columns

XaviOV — Fri, 15 May 2020 10:58:15 GMT

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

Re: Filter text 2 columns

Greg_Deckler — Fri, 15 May 2020 11:22:19 GMT

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

Re: Filter text 2 columns

nandukrishnavs — Fri, 15 May 2020 11:23:29 GMT

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 🙂

Re: Filter text 2 columns

XaviOV — Fri, 15 May 2020 12:50:41 GMT

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

Re: Filter text 2 columns

Greg_Deckler — Fri, 15 May 2020 12:56:22 GMT

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

Re: Filter text 2 columns

XaviOV — Fri, 15 May 2020 13:07:22 GMT

Hi Greg_Deckler

Regards,

Xavi

Source data:

Pregunta

Pestaña

AAARVDBU

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

Re: Filter text 2 columns

Greg_Deckler — Fri, 15 May 2020 13:16:35 GMT

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.

Re: Filter text 2 columns

nandukrishnavs — Fri, 15 May 2020 13:30:32 GMT

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 🙂

Re: Filter text 2 columns

XaviOV — Fri, 15 May 2020 13:40:13 GMT

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

Re: Filter text 2 columns

nandukrishnavs — Fri, 15 May 2020 13:41:53 GMT

XaviOV I had modified logic in the previous post.

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

Re: Filter text 2 columns

nandukrishnavs — Fri, 15 May 2020 13:44:08 GMT

XaviOV

This should work.

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