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

Ritesh_Air's avatar
Ritesh_Air
Post Patron
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!

 

 

    • mimara79's avatar
      mimara79
      Regular Visitor
      5 years ago

      Ritesh_Air thank you very much for answering and for the captures.

      Perfect, now it works correctly!

       

      Now I am trying to configure the filter so that the value "Select all" appears by default but it does not work with what I am putting.
      I know that if I put all the values ​​that exist in the "Viajante" field as seen in the screenshot below it works correctly but there are many values ​​and I would like to know if there is any other way to do it and not have to put all the values.

       

      I don't know if you or someone can help me with this.
      Thank you very much again.

       

       

      • mimara79's avatar
        mimara79
        Regular Visitor
        5 years ago

        Hi, I already found the solution to my previous post about the default "Select All".

        I put the screenshots below
        in case there is someone who has the same question and can help you.

         

        Maybe there is a better way to do it but I don't know.