Forum Discussion

RBunting's avatar
RBunting
Icon for Advocate III rankAdvocate III
7 years ago
Solved

Paginated Reports "All" parameter

I have connected Paginated Reports to a dataset that I have previously published in Power BI. I'd like to have a parameter to limit the results by Manufacturing Plant. But I'd also like to be able to...
Need Help
  • RBunting's avatar
    RBunting
    7 years ago

    Blast.  It was a picky little syntax error.

     

    EVALUATE
 ( ...

    The command shown above is no good.  Report Builder does not like that white space between the EVALUATE keyword and the open pren.  The following variation worked fine.

    EVALUATE( ...

    Thanks for taking the time to look into the problem.  

     

     

     

     

RBunting's avatar
RBunting
Icon for Advocate III rankAdvocate III
6 years ago

pdacheva,

 

My entire query is a dynamic expression that generates a valid DAX statement.

 

During the evaluation of the query text, I check the parameters and build the specific query language to send to the source system.

 

 

="EVALUATE(FILTER(...  " + iif( Parameters!Plant.Value <> "ALL", "&& 'PLANT PR1'[Plant Number] = """ & Parameters!Plant.Value & """", "") + "  ...

 

 

so, if the parameter is not set to "all," this line in the query becomes a piece of the filter conditions "&& 'PLANT PR1'[Plant Number] = "99999999".  But if the plant number IS set to "all" then this whole bit just gets omitted from the DAX query and no filter on Plant is ever applied.

 

 

 
pdacheva's avatar
pdacheva
Icon for Advocate II rankAdvocate II
6 years ago

Hi RBunting,

Thank you for your reply!

Sorry for not replying earlier - I changed the filtering of this dimension within the DAX (not using the RSCustomDaxFilter formula) and it worked as expected.

 

Best,

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi pdacheva  RBunting 

     

       Can you please share me the format of the filter in DAX? I tried but getting error.

     

    Thanks

     

    • pdacheva's avatar
      pdacheva
      Icon for Advocate II rankAdvocate II
      6 years ago

      Hi Anonymous ,

       

      Make sure you add the filter at the end of the SUMMARIZE or SUMMARIZECOLUMNS. If you share the error message maybe the community could help better. See below how I am filtering my DAX:

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi pdacheva 

         

           Thanks. "All" is working. If i set All as default then working good and if i add available values from query then All is not picking up as a default. Any idea? Can you share your email?