Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
You can also try using CONTAINS dax:
@gilbertendaya , Try a measure like
Measure =
countx(countrows(Table), filter(Table,search("Fallback",Table[IntentName],,0)>0))
or add filter to your existing measures
@gilbertendaya So maybe:
Measure =
VAR __Calc = [CountAllIntent]
RETURN
IF(SEARCH("Fallback",MAX([IntentName),,0)>0,BLANK(),__Calc)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |