Forum Discussion
Filter by Search Strings
- 6 years ago
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 - 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 Jain
Do Mark it as solution if the response resolved your problem. Do Kudos the response if it seems good and helpful.
Hi AnkitBI ,
You are a genius!!! where do you guys learn all these stuff? I go on powerbi classes but they never touch on these topics or come close to any advanced DAX queries.
Your measure works perfectly for what i was trying to do. Thank you again for taking the time to share the answer!!!
Glen