topic Re: Text filter need to restrict the wild card search drill through to the exact match input from field in DAX Commands and Tips

Text filter need to restrict the wild card search drill through to the exact match input from field

Anonymous — Mon, 17 Jun 2024 18:09:24 GMT

Hi All,

Step-1

I have a requirement like on one screen I have implemented the Text custom filter here user trying to serch some thing and exact data is matching then I need to populate a pop up that matched else not matched. how can I achieve this through DAX.

Step-2

The same filter i have used in another page by using the sync slicer functionality, if that record is matched the same will drill through the next page and showing the same matching record with respective to the selected item from the first seen.

Note: That exact match should shown not the matched data.

Expected scenario

Trying to search "Velo" from page one give me that exact match records on drill through page

Not Expected

Trying to search from "V" it should not give the matched records like below screenshot, if not matching any value then need to show the custom message like "no data available in red colour"

Could some one please help me in this scenario. that really help me a lot if someone solves this.

Thanks in advance.

Re: Text filter need to restrict the wild card search drill through to the exact match input from field

Anonymous — Tue, 18 Jun 2024 03:13:48 GMT

Hi Anonymous

Here's my test, I hope it can help you.

Sample:

1. Create a slicer table

product slicer = VALUES('Table'[Product])

2. Create a measure

Measure = IF ( SELECTEDVALUE ( 'product slicer'[Product] ) = BLANK (), 0, IF ( CONTAINSSTRINGEXACT ( SELECTEDVALUE ( 'product slicer'[Product] ), MAX ( [Product] ) ), 1, 0 ) )

3. Put the measure into the visual-level filters, set up show items when the value is 1.

Output:

4. "When there is no value matching for what you want, a pop-up window is displayed". I'm afraid it can't be achieved directly, the following method is for your reference:

Create a measure as follows:

Measure 2 = VAR _count = CALCULATE(COUNT('Table'[Product]), FILTER('Table', [Measure] = 1)) RETURN IF(_count <> 0 || _count <> BLANK(), BLANK(), "no data available in red colour")

Final Output:

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Text filter need to restrict the wild card search drill through to the exact match input from field

Anonymous — Tue, 18 Jun 2024 05:24:49 GMT

Thanks For your Reply. Its working fine as expected. Thank you so much

I just modified the measure2 below

Measure 2 =

VAR _count = CALCULATE(COUNT('Table'[Product]), FILTER('Table', [Measure] = 1))

RETURN

IF(_count <> 0 || _count <> BLANK(), "Data Found Click on View Data", "No Records Found")

Note: Is there any chance to apply the colour coding "Data Found Click on View Data" (This is in Green Colour) and "No Records Found" (This is in Red colour) If you can solve this. That really a great help for me.

Thank You so much once again.

Re: Text filter need to restrict the wild card search drill through to the exact match input from field

Anonymous — Tue, 18 Jun 2024 06:26:42 GMT

It will show only for the exact match. Below is the test case with I tried "Ve" that means not exact match in this scenario also data should not appear. below is the screenshot for reference.

Re: Text filter need to restrict the wild card search drill through to the exact match input from field

Anonymous — Thu, 25 Jul 2024 17:24:10 GMT

Hi,

In the above scenario is working fine but we have another requirement like if the value is matching we provide some custom message like " Data is available" this custom message in (green in colour), if not matching the record, then it will showing another message like "No data available " this is in Red in colour) after modifying your measure 2 query like below

Measure 2 =
VAR _count = CALCULATE(COUNT('Table'[Product]), FILTER('Table', [Measure] = 1))
RETURN
IF(_count <> 0 || _count <> BLANK(), "No data available", "Data is available")

Note : I used this measure 2 in some text box in my report. but here is one problem, if user not entering any value in the text filter the message will not go away. That will misleading to the user like he is not entering any data its showing the message that is incorrect. is there any way to restrict that in our dax formula.

If user not entering any value in the text filter that text box should show empty, if they enterns any value that qrecord is matcing then show right message else show the " No data available " mesaage that is in red colour.

Could you please look into my concern and do the needful.

Thank you so much in advance for your kind help.

Re: Text filter need to restrict the wild card search drill through to the exact match input from field

Anonymous — Tue, 30 Jul 2024 04:36:23 GMT

Hi, Is there any scenario to achieve this if exact match give some message like "Data matched" if not match "Not matched" else should populate as null. I need this requirement business is strictly need this one please check whether it is possible. Thank you for your kind help

Re: Text filter need to restrict the wild card search drill through to the exact match input from field

Anonymous — Wed, 13 Nov 2024 13:59:14 GMT

Thanks for your response it almostworking fine untill we dont have any similar records in the data. For example you can add Velo1 value in the product column and check the same scenario. it is not working for the similar record I tried from my end. so can you please alter the code and send me the upadted one if possible. Thank you so much in advance for your prompt response.

Re: Text filter need to restrict the wild card search drill through to the exact match input from field

Mobious — Tue, 10 Dec 2024 15:00:46 GMT

I just recreated this, but it's not working as shown in this post. If I try VE both VTT and Velo results come back.