Filter the projects if it exceeds the threshold , composite model

I have two table

table 1 - direct query

table 2 - Excel

relationship created using a column called - project_name

Now i have a column named dq% in table1 and column named threshold in table 2,

now i want to write a query where if dq% greater than threshold,1 else 0,

i want the above logic to be implemented in calculated column so that i can filter the values in visualisation

many function seems to not work properly between direct and import tables.

can someone help here please