RSCustomDaxFilter Documentation

Hi again,

I did get this working yesterday, but today tried to retrace my steps and realised I'd forgotten some of the fiddly details, so just replying now 😅

In short, yes, you should create a query parameter and set its value to that of the existing report parameter (in Dataset Properties > Parameters).

Also, you should avoid Query Designer (in my experience).

For completeness, the full set of steps I followed:

1. Create a new Dataset
2. In the Dataset Properties dialog box, in Parameters section, click Add.
3. Enter Parameter Name
   This can be the same name or a different name from the existing report parameter, as it is scoped to the query.
4. For Parameter Value, select the existing report parameter from the dropdown.
5. Go to Query section of Dataset Properties dialog box.
6. Specify Name & Data source
7. Don't click Query Designer. Enter or paste DAX query into Query dialog box, incorporating the query parameter defined above.
8. Click Validate Query to confirm it works, then OK.

I have to give credit to this Reddit comment where the author followed similar steps.

Regards,

Owen