Help with DirectQuery using filtered value

[MarianneAyres]

Hello,

I have a table with a subset of ID's, when I selects a row from this table I want a query to execute using this value.

For this, I've created a new measure, Target_ID that does a SELECTVALUE, of the active row in the main table.

What I'm not understanding is how to inject this new measure, target_ID, in the query that I have.

Query :

let
    T_ID = "10",
    Source = Sql.Database("LocalHost", "AdventureWorks", [Query="select a.* from(#(lf)select '1' as ID#(lf)union all#(lf)select '2' as ID#(lf)union all#(lf)select '3' as ID#(lf)union all#(lf)select '4' as ID#(lf)union all#(lf)select '5' as ID#(lf)union all#(lf)select '6' as ID#(lf)union all#(lf)select '7' as ID#(lf)union all#(lf)select '8' as ID#(lf)union all#(lf)select '9' as ID#(lf)union all#(lf)select '10' as ID#(lf)) a#(lf)where a.ID ='"&T_ID&"'", CommandTimeout=#duration(0, 0, 5, 0)])
in
    Source

Thank you for your time and help! 🙂

[v-danhe-msft]

Hi @MarianneAyres ,

Waht is your desired result? Could you mean if you select ID 2, it will retrun ID 10 with direct query mode? Is there any logic about it? 

Regards,

Daniel He