Forum Discussion
Solved
Help with multiple value search (array or table) with direct query
Hello, I struggle to find the correct solution for my problem: I have two direct query tables. Table 1 contains search terms, Table 2 contains the fields to be searched: Search tems tabl...
Hi, tosho9
I don't know this function can't be used in DQ column, but you can try to use measure to display results in table visual.
Like this:
Measure 2 = CALCULATE ( MAX( 'Table'[Search tems table] ), FILTER ( ALL ( 'Table' ), CONTAINSSTRING (max('Table (2)'[Table 2]), [Search tems table]) ) )Best Regards,
Community Support Team _ Janey
Thank you very much!
Unfortunately I get the error, that the function calculate cannot be used in direct query.
Do you have any Idea how I could do the task with direct query?
Hi, tosho9
I don't know this function can't be used in DQ column, but you can try to use measure to display results in table visual.
Like this:
Measure 2 = CALCULATE (
MAX( 'Table'[Search tems table] ),
FILTER (
ALL ( 'Table' ),
CONTAINSSTRING (max('Table (2)'[Table 2]), [Search tems table])
)
)
Best Regards,
Community Support Team _ Janey