Forum Discussion

Ritesh_Air's avatar
Ritesh_Air
Icon for Post Patron rankPost 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

mimara79's avatar
mimara79
Regular Visitor
5 years ago

Hi Ritesh_Air , 

 

Sorry but my english is not very good. I have the same doubt as NielsDW (06-25-2021 10:14 AM). Can you please elaborate where did you fill in this "Join(Parameters!GrowerGroup.value, "|").

 

I do not know if it is correct here where I have put it as seen in the screenshot below (in my case the parameter is called "Viajante"), but it does not work for me either and I have also tried to put =Join(Parameters!Viajante.Value,","). When I select a single value, it returns the correct list. When I select multiple values, a blank list is returned. 

I also have doubts if I should use the TREATAS function or some other (screenshot 2).

 

What am I doing wrong?. I hope you or someone can help me.

Thanks in advance!