cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

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

 

gilbertendaya_0-1599711875771.png

@amitchandak  @ImkeF @Tahreem24 

 

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

 

1 ACCEPTED SOLUTION
Microsoft
Microsoft

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:

9.11.2.1.png

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

 

View solution in original post

4 REPLIES 4
Microsoft
Microsoft

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:

9.11.2.1.png

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

 

View solution in original post

Super User II
Super User II

@gilbertendaya ,

You can also try using CONTAINS dax:

Column = IF(SEARCH("Fallback",Table[IntentName],1,0)>0,CountAllIntent,0)
 
Don't forget to give thumbs up and accept this as a solution if it helped you!!!
You can follow me on LinkedIn
Please take a quick glance at newly : HR Analytics Report , Hotel Management Report, and Sales Analysis Report
Super User IV
Super User IV

@gilbertendaya , Try a measure like

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

or add filter to your existing measures 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Super User IV
Super User IV

@gilbertendaya So maybe:

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

---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors