Thursday, January 26, 2023

Pass multiple values to parameters in DAX from paginated report

 Hi, 

Have u encountered how to pass multiple values in DAX filter from paginated report?

If yes, then follow the steps for implementation :)

First set parameter is set to accept multiple values from user.













Then in Dataset properties in Parameters tab, set the value of the parameter with following:

=Join(Parameters!myParameter.Value, "|")






Then inside you Query Designer, this is how you will define the filter

VAR __DS0FilterTable =  FILTER(

KEEPFILTERS(VALUES('someTable'[someCol])),               PATHCONTAINS(@myParameter,'someTable'[someCol])

)

HTH

No comments: