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:
Post a Comment