Forum Discussion
Filter by Search Strings
Hi - Apologies, should have asked for Sample Data earlier. For your case, we will need to user Loop. Please use below Measure
FindSearchString = // Get list of Selected SearchStrings Values var SearchValues = Values(SearchStrings[SearchStringVal]) // Run a Loop to check if selected SearchStrings values are present in Comments. var FindVal = ADDCOLUMNS(SearchValues,"Present",Find([SearchStringVal],max(LoanInfo[Comments]),1,0)) //Get Sum, it will be '0' if Comments doesn't contains any of the Selected Values else > 0 var SumTotal = sumx(FindVal,[Present]) Return SumTotal
Update PBIX file below.
http://www.mediafire.com/file/bhv7gwuyylcbq75/For_Upload_Ankit.pbix/file
Thanks
Ankit JainDo Mark it as solution if the response resolved your problem. Do Kudos the response if it seems good and helpful.
Hi Glen,
You can use this Measure 'FindResults' and put in a Visual Filter pane for Base visual with Loan and Notes. Set the Visual Filter to value is '1'
Based on KeyWords selection in Slicer, base visual will only show rows which have matching KeyWords in Notes.
You can create a seperate measure and test it out in sepearte Visual. if it works then you can remove others.
Thanks,
Ankit Jain
Hi AnkitBI ,
For some reason the measure you gave does not show any results. I modified the SearchKey var and was able to get results. But it only works on single select. If i select more than 1 keywords, then it displays everything.