Forum Discussion
Containsstringexact or containsstring but NOT substring, only whole selected word?
- Anonymous1 year ago
Thanks for bhanu_gautam's concern about this issue.
Hi, SevsBo
Since you didn't provide me with some test data, I assumed some data myself for testing:
You can then create a Calculated column to determine the original name if it is Red Box or Green Box, and null if it is not:
ExactMatch = IF ( ([Product Name] = "Red Box") || ([Product Name] = "Green Box"), [Product Name], BLANK() )Then create a Measure:
ExactMatchMeasure = COUNTAX ( FILTER ( 'Table', NOT(ISBLANK([ExactMatch])) ), [ExactMatch] )Finally drag the created Measure to the Filters panel to filter the data:
I have attached the pbix file for this simple example below, I hope it helps.I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for bhanu_gautam's concern about this issue.
Hi, SevsBo
Since you didn't provide me with some test data, I assumed some data myself for testing:
You can then create a Calculated column to determine the original name if it is Red Box or Green Box, and null if it is not:
ExactMatch =
IF (
([Product Name] = "Red Box") || ([Product Name] = "Green Box"),
[Product Name],
BLANK()
)
Then create a Measure:
ExactMatchMeasure =
COUNTAX (
FILTER (
'Table',
NOT(ISBLANK([ExactMatch]))
),
[ExactMatch]
)
Finally drag the created Measure to the Filters panel to filter the data:
I have attached the pbix file for this simple example below, I hope it helps.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.