Filtering with matches ID in spouse or main

[sebastianip]

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.

[TomMartens]

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

[TomMartens]

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

[sebastianip]

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