Filter a value based on a word in a string

[Anonymous]

Hello Everyone

I am trying to create a mesaure that filters a value based on a word in a text string. The string i build like this "WordA, WordB, WordC, WordD" The word i want to filter is showing up in random places for every row.

I have tried different things and it is not working for me.

Any help is greatly apprenticed.

[Mariusz]

Hi @Anonymous 

Can you create a data sample and explain if you are looking for a specific fixed word or do you want to select the word from the slicer?

Best Regards,
Mariusz

Please feel free to connect with me.

[Anonymous]

Hi @Mariusz 

Thank you for your answer 

and sorry for not being specific enough

Yes i am looking for a specific fixed word every time.

I made a table to better explane it

values that contains WordC get copyed over to a new coulmn.

[v-frfei-msft]

Hi @Anonymous ,

We can make it dynamicly by creating a measure based on a slicer.

Measure = 
VAR a =
    SEARCH ( SELECTEDVALUE ( Slicer[Filter] ), MAX ( 'Table'[Text] ),, BLANK () )
RETURN
    IF ( a = BLANK (), BLANK (), MAX ( 'Table'[Value] ) )

PBIX as attached.

[Anonymous]

Thank you for your answer @v-frfei-msft 

It is an interresting way to solve the problem. But i am trying to avoid using a slicer.

@Mariusz  Thank you for your anwser it was just what i was looking for. I appreciate that you gave an example with both a measure and a coulmn.

Not to be rude but is there a way to filter the other way around so that it excludes a tag instead of only searching for one tag?

I need to use it the other way around in another report.

Again thank you for your answers.

[Mariusz]

Hi @Anonymous 

Sure, all you need to do is replace ">" with "=" like below.

Column = 
IF( 
    SEARCH( "WordC", 'Table'[Text], 1, 0 ) = 0, 
    'Table'[Value] 
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Mariusz · Accepted solution]

Hi @Anonymous 

Please see the below.

Column = 
IF( 
    SEARCH( "WordC", 'Table'[Text], 1, 0 ) > 0, 
    'Table'[Value] 
)

Measure = 
SUMX( 
    FILTER(
        'Table',
        SEARCH( "WordC", 'Table'[Text], 1, 0 ) > 0 ),
    'Table'[Value]
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.