Build a table relationship using OR

[Rjesak]

I have a table of services, a table of clients, and a table of contacts. My contacts are joined either to the client table OR the service table. I'm trying to figure out how to build this relationship in Power BI.

service to client is a one to one relationship

client to contacts is a one to many relationship

service to contacts is a one to many relationship

Here's a stripped down version of the tables:

Services
service_seq	Service Type	client_seq
111	aaa	999
222	bbb	888
333	aaa	777

Client
client_seq	client name	client address
111	Mr. A	B street
222	Mr. B	C street
333	Mrs. C	D street

Contact
service_seq	client_seq	contact info
111		Dr. A
	888	Dr. B
222		Dr. C
222		Dr. D
	777	Dr. E

Any thoughts?

[amitchandak]

@Rjesak ,

Join the contract with both.

And keep Service and client relation inactive. Activate in the formula as per need. Using userelation. Also deactivate a relation with contract using crossfilter

Refer https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...