Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
sebastianip
Frequent Visitor

Filtering with matches ID in spouse or main

I have two tables one is a donation table and one is the donor record.

I have linked the donation[donor_id] and donor[id_number] together.

 

And all slicers filter the donation records. The donor records are shown based on the donation records selected.

 

Is there any way that can make the donor records shown when the donation record[donor_id] is matched with the ID_number or spouse_ID_number

 

Thank you so much.

3 REPLIES 3
TomMartens
Super User
Super User

Hey @sebastianip ,

 

create a pbix file containing sample data that still reflects your semantic model (tables, relationships, calculated columns, and measures). Upload the pbix to OneDrive, Google Drive, or Dropbox, and share the link. If you are using a spreadsheet to create the sample data instead of the manual input method, share the spreadsheet as well.

 

Explain the expected result based on the sample data you provide.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
TomMartens
Super User
Super User

Hey @sebastianip ,

 

yes, you can. Change the cross-filter direction between the table donation and donor to both so that the table donation will also filter the donor table.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

@TomMartens 
Thank you for replying.

 

But I am stuck. It just filters out the matches of donation[donor_id] and donor[id_number].

Is there any way I can change the condition to all those matches in donor[id_number] or donor[spouse_id_number].

 

Thank you so much.

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.