Forum Discussion
XaviOV
Helper V
Helper VFilter 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...
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 🙂
nandukrishnavs
Community Champion
Community Champion
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 🙂
XaviOVHelper V
Helper VHi 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
- nandukrishnavs
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 🙂