Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

relationship trouble: data not being able to be filtered correct

Hi All,


I am having problems with my relationships since you cannot have too many active/make them both. The "plan total" and "activity total" have the data. The "plan products" and "activity prodcucts" have the products and "plan geo" and "activity geo" have the geography broken down. As you can see there are multiple ways that each can be broken down, they are a little different but also the same, so  created "Products full match" and "geography full match" to combine both plan and activites seperate sheets together. THat then causes the problem of "duplicates" so i still need to first connect to their own sheets and then I can go onto the next relationship. I am unable to get the relationships to work so I am able to filter the "Plan Total"and "Plan Acitivty" by "Products Full Match" and "Geography Full match" as well as matching with the "Date" colum. 

If anyone knows how to fix this so I do not keep getting repeating numbers and am able to filter these correctly. Not sure how the relatinships could go?




Super User IV
Super User IV

@alisonpappas there is a lot more going on in your model, yes you cannot have two active relationships with one table.  It is ok to have an inactive relationship, you can have only one active relationship between tables, to use inactive relationship in your measure, use userelationship function to make inactive relationship active.

Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Hi @parry2k ,


When I use the "userelationship" i am unable to filter still. it also gives me the same output. I am wondering if there is a way to condense? 

Helpful resources

November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!


Power Platform October Community Highlights

Check out the top community contributors across all of the communities


Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors