Measure to display query string parameter from report url

[abhiram342]

Hi all - We have created report based on dynamic m paramters using direct query. We want to pass query string paramter from report url and assign the value to dynamic m parameter. Currenlty, the functionality Works fine but only issue is we want to know what's parameter value being passed in the url . I created measure but it's not working fine. Can you please help.

Example:

Model:

Result by passing below parameter to report (filter=ProductSearch/ProductIdFilter eq 'Job6789_8d02ac83dfd6')

functionality works fine but Selected Value is displaying Blank

SelectedValue = SELECTEDVALUE('ProductSearch'[ProductIdFilter])

Thanks,

Abhiram

[lbendlin · Accepted solution]

needs to be a column and that column needs to be bound to the dynamic M parameter.

[abhiram342]

Thanks @lbendlin ! Our dataset size is big hence using this approach.