Forum Discussion

gilbertendaya's avatar
gilbertendaya
Icon for Helper IV rankHelper IV
6 years ago
Solved

Remove in matrix table if word Fallback is present

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  ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
Tahreem24
Icon for Super User rankSuper User
5 years ago

gilbertendaya ,

You can also try using CONTAINS dax:

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