Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
gilbertendaya
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
v-eqin-msft
Community Support
Community Support

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
v-eqin-msft
Community Support
Community Support

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

 

Tahreem24
Super User
Super User

@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!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
amitchandak
Super User
Super User

@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
Super User
Super User

@gilbertendaya So maybe:

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.