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.  

     

     

     

     

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:

V_20's avatar
V_20
Frequent Visitor
2 years ago

Hi RBunting Craig_Donoghue RuchikaSoni pdacheva mvabalaitis 

 

I am running into the same requirement. I could not use RsCustomdaxfilter and filter dax function in the same query. The query is not picking up the parameter. 
would you let me know how you used both like in the image shared above? 

  • RuchikaSoni's avatar
    RuchikaSoni
    Icon for Advocate I rankAdvocate I
    2 years ago

     This is how I used it. All my parameters are defaulting to "ALL".

    FILTER('TreatyMaster_BI',(@UA= " ALL" || PATHCONTAINS (@UA ,'TreatyMaster_BI'[Underwriting Assistant]))),
RSCustomDaxFilter(@ConversionTypeCurrencyConversion,EqualToCondition,[Conversion Type].[Currency Conversion],String), 
FILTER(VALUES('Transaction Dates'[Date]), (vFromTransactionDatesDate1ALL || 'Transaction Dates'[Date] >= DATEVALUE(vFromTransactionDatesDate1) + TIMEVALUE(vFromTransactionDatesDate1)) && (vToTransactionDatesDate1ALL || 'Transaction Dates'[Date] <= DATEVALUE(vToTransactionDatesDate1) + TIMEVALUE(vToTransactionDatesDate1))), "Written Premium", [Written Premium], "Earned Premium", [Earned Premium], "Total Paid Loss", [Total Paid Loss], "Additional Case Reserve",