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 

 

One more update:

 

If I change my variable to this:

 

  VAR __DS0FilterTable2 = 
    FILTER(
      VALUES( 'Enrolled Growers'[Program_Group_Name] ),
      PATHCONTAINS(@GrowerGroup, 'Enrolled Growers'[Program_Group_Name] )
    )

 

I don't get any syntax error and query runs fine. If I choose 1 value from the drop down list, I get correct result, but if I choose multiple then I get no data. So somehow, it doesn't recognize multiple values, even after using PATHCONTAINS functions. I am stumped. 😞

 

Thanks,

-RK