topic How to list out my output results in DAX Commands and Tips

How to list out my output results

Wendy_WL — Sat, 07 Sep 2024 06:47:02 GMT

Lookup keyword using "Searchsheet" table to find match in "Stringsheet" table.

2 types of conditions:

(i) When BOTH [Search1] AND [Search2] are found in "Stringsheet" table;

(ii) When Either [Search1] OR [Search2] are found in "Stringsheet" table;

List out the results found. Appreciate your help greatly to list out the results found in yellow highlights below. I am not familiar with List function. Thank you.

Link for my Power Bi file : List out results

ContainsString AND =

VAR __String = [String1]

VAR __Table =

ADDCOLUMNS(

'Searchsheet',

"Found", CONTAINSSTRING( __String, [Search1]) &&

CONTAINSSTRING( __String, [Search2]))

VAR __Result = IF( COUNTROWS( FILTER( __Table, [Found] = TRUE() ) ) > 0, TRUE(), FALSE() )

RETURN

__Result

ContainsString OR =

VAR __String = [String1]

VAR __Table =

ADDCOLUMNS(

'Searchsheet',

"Found", CONTAINSSTRING( __String, [Search1]))

VAR __Table1 =

ADDCOLUMNS(

'Searchsheet',

"Found", CONTAINSSTRING( __String, [Search2]))

VAR __Result = IF( COUNTROWS( FILTER( __Table, [Found] = TRUE() ) ) > 0, TRUE(), IF( COUNTROWS( FILTER( __Table1, [Found] = TRUE() ) ) > 0, TRUE(), FALSE() ) )

RETURN

__Result

Re: How to list out my output results

tharunkumarRTK — Sat, 07 Sep 2024 09:04:35 GMT

your file is not accessible. Please grant the permissions

Re: How to list out my output results

Wendy_WL — Sun, 08 Sep 2024 07:53:17 GMT

Thank you very much, I have grant the permission.

Here is the link again :

https://drive.google.com/drive/folders/1fWS2SbPwFJwf6Xp8aqdYtIJ4KDCU87hb?usp=drive_link

Re: How to list out my output results

Anonymous — Tue, 10 Sep 2024 01:19:39 GMT

Hi Wendy_WL ,

I’ve made a test for your reference:

List For And = CONCATENATEX( FILTER( Searchsheet, CONTAINSSTRING(Stringsheet[String1], Searchsheet[Search1]) && CONTAINSSTRING(Stringsheet[String1], Searchsheet[Search2]) ), Searchsheet[Search1] & " " & Searchsheet[Search2], "; " )

List For Or = CONCATENATEX( FILTER( Searchsheet, CONTAINSSTRING(Stringsheet[String1], Searchsheet[Search1]) || CONTAINSSTRING(Stringsheet[String1], Searchsheet[Search2]) ), Searchsheet[Search1] & " " & Searchsheet[Search2], "; " )

Best Regards,
Bof