Forum Discussion
Paginated Report
Hello, thank you for the help.
I use RRSCustomDaxFilter in the Dataset as a Filter. How can i configure the Parameter / the Dataset Query, so that all Items are selected but not in the Query that gets executed(As you mentioned "All as not filter in the dataset query").
Hi LaurenzR , Thank you for reaching out to the Microsoft Community Forum.
With RSCustomDaxFilter, you shouldn’t let it run when All is selected, because that’s what expands into a huge filter. I suggest you introduce an All option in your parameter (e.g., value = “ALL”) and then make your dataset query conditional: if the parameter = “ALL”, you skip RSCustomDaxFilter entirely (no customer filter applied); otherwise, you apply RSCustomDaxFilter as you do today. In other words, All should translate to no filter in the query, not a filter containing every customer, that’s what prevents the query from becoming too complex in the Service.
Thanks for your help. I think i found a way to implement this solution into my Dax Dataset Query, but when i want to try it i get the Error: "RSCustomDaxFilter is not a valit table, variable or expression name". I have got this error also in the past but have not realy found why this happens and how to fix it
Hi LaurenzR ,
RSCustomDaxFilter isn’t an actual DAX function, it’s a placeholder that Report Builder only recognizes in its original position in the query. If you try to wrap it in IF, use it in a variable or move it around, the engine can’t resolve it and throws that error.
So, instead of making it conditional in DAX, keep RSCustomDaxFilter exactly where it is and control it through the parameter. Add an ALL option and when that’s selected, pass a blank/Nothing value to the parameter so the filter doesn’t get applied. That way All behaves like no filter, without breaking the query.
I tried checking if everything is selected and if so than ignore the parameter but you cant use conditions in combination with RSCustomdaxfilter so that did not work. also the all element did not work, because there would be 10 entries for "All" if there were 10 customers and when i made it that the All Element only appears once, then the RSCustomDaxfilter filters the dataset with the Value "all" and returns nothing because there is no such element in the base data.
i dont have any clue what else i could try