Measure to display query string parameter from report url

abhiram342 — Mon, 26 Feb 2024 21:58:06 GMT

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

Re: Measure to display query string parameter from report url

lbendlin — Tue, 27 Feb 2024 01:29:48 GMT

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

Re: Measure to display query string parameter from report url

abhiram342 — Tue, 27 Feb 2024 02:31:34 GMT

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

topic Re: Measure to display query string parameter from report url in DAX Commands and Tips

Measure to display query string parameter from report url

Re: Measure to display query string parameter from report url

Re: Measure to display query string parameter from report url