relationship trouble: data not being able to be filtered correct

[alisonpappas]

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?

[parry2k]

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

[alisonpappas]

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?