Bound Parameter not picking up the selection from the user.

[Anonymous]

I must be missing something that's right in front of me.

I have two tables. I want the user to click on the URL in table one and have the parameter picks the clicked ReportURL and filter the second table using that chosen URL

Now I have a parameter created as text named "Page", and that parameter is embedded into the code on the "Device datalake table.  A snippit of the code "  AND ReportURL like '%" & @Page & "%'" & "

The table is by default, filtering by the default value set up in the Page parameter. So I know the code is working as expected.

Ideally i want the user to click on the selection on the table and/or a slicer and whatever they clic, the parameter picks up on it and details are visible based on selection.

Problem is that anything the user chooses is ignored.  How do I create what I need so that any click from the user changes the value so the second table is filtered? That's the part I'm stuck on.

Any help is appreciated.  Thanks, Steven 

[amitchandak]

@Anonymous , if two tables are connected it will filter.

or you have to use measure in visual or visual level filter

Measure = Countrows(Filter('Data Intake', 'Data Intake'[Report URL] in values(WCMS[Report URL]) ) )

or use treatas https://docs.microsoft.com/en-us/dax/treatas-function

[Anonymous]

Thanks for the response.  However, it seems to me that none of those things listed seem to force the query to update, myabe I'm missing something?
When I track the parameter after i click on a different value, the value in the parameter that I set as default, doesn't change, whether I connect the tables in the data model or not.