cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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 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

 

 

 

2 REPLIES 2
seeligt
Regular Visitor

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.

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!