SSRS Multi-Value parameter using DAX

SSRS Multi-Value parameter using DAX

In this post, we will how to set up multi-value parameters in SSRS using DAX.

Setting up Multi-Value Parameter using DAX in SSRS with 3 steps

For those who are already familiar with SSRS using MDX, it’ll be pretty straightforward as this is exactly the same logic, only the syntax changes and of course the language.

In this post, I’m using the AdventureWorks Tabular model database which you can download here

1. Multi-Value Parameter

We first need to create a parameter e.g “param_CountryRegionName” and then generate the country with the following DAX query:

EVALUATE SUMMARIZECOLUMNS('Geography'[Country Region Name])

After running the above code in the DAX designer we can see the multiple values of the CountryRegionName parameter.


2. Main Data Set

Once the parameter list is ready we need to create our main dataset.
We want to return the following:

  • Internet total sales
  • Margin
  • Results grouped by Product Category
  • Ability to filter by Country Region and by Fiscal Year
'Product Category'[Product Category Name],
VALUES ( 'Geography'[Country Region Name] ),
PATHCONTAINS ( @CountryRegionName, 'Geography'[Country Region Name] )
VALUES ('Date'[Fiscal Year] ),
PATHCONTAINS ( @FiscalYear, 'Date'[Fiscal Year] )
"Internet Total Sales", [Internet Total Sales],
"Internet Total Margin", [Internet Total Margin]

Here the trick is to use PATHCONTAINS; in this example, PATHCONTAINS creates a string as a result of evaluating the parameter values and then checks for each country if they’re among the parameter values string.

3. Link the parameters to the main data set


SSRS DAX multi-value parameters

Here the second trick is to use the SSRS function “Join” to concatenate the list of the selected parameters with a pipe.

Note: You must concatenate your parameter values with a pipe “|” as the Pathcontains function expects a pipe-delimited string. (Read more about the DAX PATHCONTAINS  and PATH functions)


4 thoughts on “SSRS Multi-Value parameter using DAX

    1. hi Ernesto yes I did use it with dates back in the time but it usually requires come extra casting using SSRS functions

  1. Thanks, this helped me parse a multi-value parameter querying a power bi dataset using DAX. I could get a single value to pass, but the multivalued parameter was erroring out.

Leave a Reply

Your email address will not be published. Required fields are marked *