topic Re: RSCustomDaxFilter - Paginated Report in DAX Commands and Tips

RSCustomDaxFilter - Paginated Report

Anonymous — Thu, 30 Jul 2020 22:59:26 GMT

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 RSCustomDaxFilter? In case user selects Work Id, Last Name should be passed as null.

EVALUATE SUMMARIZECOLUMNS('Sample Data'[First Name], 'Sample Data'[Last Name], 'Sample Data'[Worker ID], 'Sample Data'[License Number], 'Sample Data'[Jurisdiction], 'Sample Data'[JurisdictionDesc], 'Sample Data'[Company Name], 'Sample Data'[EmployeeOfficeLocation], 'Sample Data'[Processing Date], 'Sample Data'[Author/Content Credits], 'Sample Data'[Instructor Credits], 'Sample Data'[Learner Credits], 'Sample Data'[Carry Applied], 'Sample Data'[Rule Applied], 'Sample Data'[subjectType], 'Sample Data'[courseCode], 'Sample Data'[providerRegistryNumber(Sponsor ID)], 'Sample Data'[providerName], 'Sample Data'[courseLocationState], 'Sample Data'[Multi-Year RP End Date], 'Sample Data'[Multi-Year RP Start Date], 'Sample Data'[courseDateEnd], 'Sample Data'[courseDateStart], 'Sample Data'[courseDeliveryMethod], 'Sample Data'[courseName], 'Sample Data'[Limitation Reason], RSCustomDaxFilter(@SampleDataLastName,EqualToCondition,[Sample Data].[Last Name],String), RSCustomDaxFilter(@SampleDataJurisdictionDesc,EqualToCondition,[Sample Data].[JurisdictionDesc],String), RSCustomDaxFilter(@SampleDataWorkerID,EqualToCondition,[Sample Data].[Worker ID],String))

Thanks,

Fayyaz

Re: RSCustomDaxFilter - Paginated Report

amitchandak — Fri, 31 Jul 2020 03:18:59 GMT

Anonymous , refer https://community.powerbi.com/t5/Desktop/Paginated-Reports-Parameters/m-p/1089587

https://docs.microsoft.com/en-us/power-bi/paginated-reports/report-builder-url-pass-parameters

https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-parameters

Re: RSCustomDaxFilter - Paginated Report

seeligt — Fri, 07 May 2021 08:09:03 GMT

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.

Re: RSCustomDaxFilter - Paginated Report

martim224 — Wed, 29 Jun 2022 15:53:30 GMT

Did this resolve you issue? Having the same problem and Report Builder does not like the changes when I try this.

Re: RSCustomDaxFilter - Paginated Report

Kubrasenses_ — Thu, 09 May 2024 10:23:48 GMT

Hi,
Would you resolve this issue? I have the same problem but i cant resolve. ı 've been searching a lot. if you resolve can you share me to resolve?