Urgent help needed - filtering on tables with no relationship

[Anonymous]

I have 3 tables:

(1) Users

(2) Churn Reasons

(3) User Tags

Churn reasons is connected to my Users lookup table on UserID, User Tags is also connected to my Users lookup table on UserID. I want to be able to filter my list of churn reasons by specific user tags (ie. list only churn reasons for customers with tags 1, 2, 3). How can I do this if there is no relationship? 

[Pragati11]

Hi @Anonymous ,

Can you please put a screenshot of the relationships among these tables?

Thanks,

Pragati

[Anonymous]

The users table is "public users", the box on the bottom left is the "tag table" and the box on the bottom right is the "churn reason" table @Pragati11 

[v-yuta-msft · Accepted solution]

@Anonymous ,

You need to modify the relationship between 'tags' table, 'user' table and 'churn reason' table. The relationship should be change with pattern

'tag' one->many 'user'
      one->one

'user' one->many 'churn reason'
       one->one

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.