Paginated Reports DAX for multi-select parameter

[tommy_g]

I am integrating a Paginated Report into my Power BI app. I have successfully linked my slicer values with the report paramters.

I have no problem with a single selection. However, I know I have to do something more to get a multiple select filter to work with the DAX query.

First screenshot shows my desired result. a report which include three parameter values. (currently only the first parameter is in effect)

 

The Parameter Value text is created as follows: 

DAX Parameter substitution:

What I need is a way to expand the parameter to include all values, similar to the join used for the text box. The parameter works when I trim it to "Parameters!Fleet_Name.Value(0)". 

I need to figure out where and how to deal with a multi-valued parameter.
In T-SQL I would use an "in('a','b','c'). I probably need to find a DAX equivalent

[v-jayw-msft · Accepted solution]

Hi @tommy_g ,

Check if this topic could help.

https://community.powerbi.com/t5/Desktop/DAX-for-PowerBI-Paginated-Report-Multiple-Values-Selected/m... 

Best Regards,

Jay

[tommy_g]

I was hoping for a personal DUUHHHH, in that I was missing something totally obvious or making a simple syntax error. Sadly not, this is apparently an issue where Paginated for Power BI fails due to complexities with DAX. I have verified via SSRS that multiple parameters work exactly as advertised. I hope PBI catches up.

I will accept your pointer to RSCUSTOMFILTER as the closest possible solution, thanks.

[tommy_g]

Adding context, basically I need to get from Exhibit A to Exhibit B. I've tried joins, string manipulation, etc. No luck.

What I get from Power BI:

What I need to get me here in Report Builder: