Filtering with a sub filter with multiple value selection - will not work for Report Builder PR

Hi, Karolina411 

According to your description, I use create a datatset using the following SSAS data and filter it by parameter:

EVALUATE
SUMMARIZE(FILTER('UserInfo','UserInfo'[Name]=@Username),UserInfo[Age],UserInfo[Income],UserInfo[Name])

As you write it, it will return blank when the parameter selects multiple values:

Single value:

Blank is returned when multiple values are selected:

We need to change the query statement to the following using RSCustomDaxFilter:

EVALUATE
SUMMARIZECOLUMNS(UserInfo[Age],UserInfo[Income],UserInfo[Name],
RSCustomDaxFilter(@Username,EqualToCondition,[UserInfo].[Name],String))

Then when we pass the multiselect parameter, it works:

You should change the parameters that you need to pass multiple values ​​to use RSCustomDaxFilter to reference these parameters. You can refer to the following blog:

Chris Webb's BI Blog: Power BI Report Builder And RSCustomDaxFilter (crossjoin.co.uk)

Introduction to DAX for paginated reports - Simple Talk (red-gate.com)

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.