KPI and Filter Pane doesn't work with variable in the expression in Direct Query Approach

[vsabbise]

I am using a Direct query approach since I have millions of data to work with and full load is not practical.

My Direct Query:

DIRECT QUERY
dimension
[cf_id],
[c_id],
[txt],
[file]
measure
1 as record_count
FROM table_x;

The Load was successful and I can do basic KPI with the data.

1) But the KPI doesn't yield correct result when I use set analysis. (Expression in KPI)

Example: (vWord1 is my input box variable)

=count(distinct {<file = p({<txt= {"*$(#vWord1)*"} >}) >} [c_id])

2) Also few qlik sense functions doesn't yield correct result. (Expression in Filter Pane)

=if(txt = vWord1, txt)