Forum Discussion
Paginated Report
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
Hi LaurenzR , Thank you for reaching out to the Microsoft Community Forum.
Separate the All case from the filtered case. Keep your current parameter for customers, but add a second flag parameter (e.g., Show All). Then in the dataset parameter mapping, pass the customer values only when filtering is needed and pass Nothing/blank when All is selected so no filter gets applied. If your setup doesn’t handle blank cleanly, use two datasets (one with RSCustomDaxFilter, one without) and switch between them, this avoids the issue entirely.
But if i pass Nothing to the RSCustomDaxFilter Function, then i wont get any customers back or am i wrong