Forum Discussion
RSCustomDaxFilter - Paginated Report
Hi Team, I'm working on paginated report. I want to make Last Name and Worker Id parameters optional. User can seleter either Worker Id or Last Name. Can you please help me add a Or conditon in ...
Hello!
RSCustomDaxFilter is a dynamic expression. Maybe you can transform it in general Dax-Code like FILTER()
and add the OR()-function and combine it with the ISBLANK()-function for your optional parameter.
I will try to explain it with your example...
RSCustomDaxFilter(@SampleDataLastName,EqualToCondition,[Sample Data].[Last Name],String)
transformed:
FILTER(VALUES('Sample Data'[Last Name]), OR(('Sample Data'[Last Name] = @SampleDataLastName), ISBLANK(@SampleDataLastName)))
Best regards.