Remove in matrix table if word Fallback is present

[gilbertendaya]

Hi Team,

I would like to ask for  your assistance on how to filter out the results if the column contains the word "Fallback" in matrix table.

see below

@amitchandak  @ImkeF @Tahreem24 

IntentName is the column and CountAllIntent is a measure.
Thank you.

[Eyelyn9 · Accepted solution]

Hi @gilbertendaya ,

According to my understand , you want to remove the rows when the values of Intent Name contains “Fallback”,right?

You could use the CONTAINSSTRING() function like this:

countAll=
IF (
    CONTAINSSTRING ( SELECTEDVALUE ( Table1[IntentName] ), "Fallback" ),
    BLANK (),
    SUM ( Table1[Value] )
)

 My visualization looks like this:

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

Best Regards,

Eyelyn Qin

[Tahreem24]

@gilbertendaya ,

You can also try using CONTAINS dax:

Column = IF(SEARCH("Fallback",Table[IntentName],1,0)>0,CountAllIntent,0)

[amitchandak]

@gilbertendaya , Try a measure like

Measure =
countx(countrows(Table), filter(Table,search("Fallback",Table[IntentName],,0)>0))

or add filter to your existing measures 

[Greg_Deckler]

@gilbertendaya So maybe:

Measure = 
  VAR __Calc = [CountAllIntent]
RETURN
  IF(SEARCH("Fallback",MAX([IntentName),,0)>0,BLANK(),__Calc)