Forum Discussion
Helper VFilter text 2 columns
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.
FilterColumn = VAR _id = SUMMARIZE ( FILTER ( 'Table', 'Table'[Pregunta] IN { "Fundidores", "Filtro Emulgente" } ), 'Table'[ID] ) VAR _result = IF ( 'Table'[ID] IN _id , "Show", "Hide" ) RETURN _resultThis should work.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Community Champion
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
_resultNow you can filter this column.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Helper VHi 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
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.