How to do a Direct Query from a SQL Server Stored Proc and pass Measure value as input parameter?

[Anonymous]

I have the following query definition in my Power Query - Advanced Editor:

Currently the value for the input parameter @DepartmentID is hard-coded to 'E126' as shown below:

let
    Source = Sql.Database("DbServer1", "DbName", [Query="EXEC [emsdba].[des_pb_QDepartmentByDepartmentID] @DepartmentID = 'E126'"])
in
    Source

I have a calculated Measure: 'QDepartment'[Measure_UserDepartment]

I want to pass the value in this measure as the value for the input parameter in the above stored procedure. Please let me know how to do this?

[parry2k · Accepted solution]

@Anonymous you cannot pass your measure value to query, you can create parameter and can pass parameter value to query but not measure.