I am using a multi-valued parameter in paginated reports and the report loads only if I select one value, when I select 2 or more or ALL, it doesnt work.

Question

I am using DAX in my query designer and any help would be appreciated.

Thanks

Answer 1

Hi @Nimisha Vernekar ,
Although it is possible to use DAX to retrieve tabular data in SSRS reports and you could even add parameters to DAX queries. But usually the conventional method of adding parameters only works if you want to base your results on one value at a time.

For more information about using multi-valued parameters, please refer to:
Handling SSRS Multi-Valued Parameters in DAX Queries.
SSRS Multivalue Parameters in DAX.

I would recommend you to use sql server data source and TSQL statement query, because it makes things a lot easier. Please see: Add a multi-value parameter to a paginated report.
Hope this helps.
Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.