Issue with relationships / filtering data

[MatH]

Hello, I was hoping for some help from the more advanced users here.

I work for a charity and we're trying to look at our fundraising income in Power BI and events income. I had the report working but when I changed my data source from being a local file to a SharePoint folder it seems to have broken and I can't work out how to fix it. I have a copy of the old file so I was trying to just copy it but it won't let me in the new report.

I have a date table set up, and then three more tables

1. Gift Data - all gifts on the database
2. Event Data - list of all events on the database
3. Participants Data - list of all participants on events

All of these have the standard One to Many relation ship from the Date table based on their Gift / Event date column.

I then have a 'Record ID' in both the Gift Data / Participants data and an Event ID in both Event Data / Participants Data.

My first page is all fine with just information based on the Gift Data table mostly, but then I wanted to have a page just looking at income from those records who are event participants. Originally I'd filtered the page to by 'Event ID is not empty' and it seemed to work as I had relationships set up which seemed to enable this. But now Power BI won't let me have more relationships as it says it would introduce ambiguity.

What would be your reccomendations to be able to filter the gift data to just be those related to events/participants. I really appreciate any support from the community and those with more advanced skills here.

[v-binbinyu-msft · Accepted solution]

Hi @MatH ,

Please try to create a measure to get it.

Bi-directional relationships can introduce multiple, and therefore ambiguous, filter propagation paths between model tables. When evaluating ambiguity, Power BI chooses the filter propagation path according to its priority and weight.

For more details, you could read related document: Model relationships in Power BI Desktop - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.