How can i join columns from two tables with relation using DAX query

[anz999]

Hi,

I'm trying to combine columns from two tables by applying a filter against table1 and retireve columns from the other table. Both tables have data model relationship setup. Below is the query I'm using to pull the columns from table2 but it seems to be pulling pulling all the rows instead of joining the tables. Is there any other way to join two tables like we do in Sql.

EVALUATE
SUMMARIZECOLUMNS(
table1[AzureAccountId],
table1[username],
table2[ScriptInsertedDt],
KEEPFILTERS( FILTER( ALL( table1[username] ), SEARCH( "search_string", table1[username], 1, 0 ) >= 1 ))
)
ORDER BY
table1[AzureAccountId] ASC,
table1[username] ASC,
table2[ScriptInsertedDt] ASC

[tamerj1]

Hi @anz999 

what is the relationship between the two tables? Based on which column? Which if them is the one side and which is the many?