Forum Discussion

Ritesh_Air's avatar
Ritesh_Air
Post Patron
5 years ago
Solved

Paginated Report - multiple parameter via DAX query

Hello, I am using DAX generated from PowerBI report (using Performance Analyzer) and using it in Paginated report. When the parameter has multiple values, the query doesn't understand it and returns ...
Need Help
  • Ritesh_Air's avatar
    Ritesh_Air
    5 years ago

    Ahhhh...the solution was pretty easy. Putting it out here, in case, anyone runs into the same issue.

     

    =Join(Parameters!GrowerGroup.Value,"|")

     

    Thanks,

    RK

Jon-Heide's avatar
Jon-Heide
Microsoft Employee
5 years ago

Hey Ritesh, the RSCustomDaxFilter when executed does a literal string replacement with FILTER(VALUES(...). So you could try getting your query from the perf analyzer with a single hardcoded FILTER() in the query. Then, just replace that filter with RSCustomDaxFilrer(...). Take a look at Chris Webb's blog for a good rundown on what it does. 

 

https://blog.crossjoin.co.uk/2019/11/03/power-bi-report-builder-and-rscustomdaxfilter/

  

Ritesh_Air's avatar
Ritesh_Air
Post Patron
5 years ago

Jon-Heide Thanks for your input.

 

Can you please explain further? I don't see it coming as FILTER (VALUES.....) while I put single filter. How would I force it to generate FILTER (VALUES....) code? I get TREATAS code....

 

I put a single filter in the filter pan and I get this:

 

// DAX Query
DEFINE
VAR __DS0FilterTable =
TREATAS({"172 Garing"}, 'Enrolled Growers'[Program_Group_Name])

 

If I replace the line as this:

 

// DAX Query
DEFINE
  VAR __DS0FilterTable = 
   RSCustomDaxFilter(@GrowerGroup,EqualToCondition,
   [Enrolled Growers].[Program_Group_Name],String))

 

It didn't work. Now I tried Chris's blog and tried this: Using PATHCONTAINS.

 

  VAR __DS0FilterTable2 = 
 filter(
Enrolled Growers
, pathcontains(@GrowerGroup, Enrolled Growers[Program_Group_Name])
)

 

Option # 1: Replacing TREATAS as RXCUSTOMFILTER

 

Option 2: replacing TREATAS as PATHCONTAINS...

 

I get error saying it's not correct.

 

 

What am I doing wrong?

 

Thanks for your help!

-RK