Relationship between two Tables

[Kaskazi_Network]

Hi all,

So I have two tables, 'Outlets Table' and 'Customer/Distributor Table' as shown in the dummy tables below. I need to create a relationship betwen the two tables so that I can show Comparison in number of outlets and number of customers for each distributor in a single visual. Kindly, advise how I can relate the two tables and achieve the above.

Any feedback will be highly appreciated, thanks.

Outlets Table
Outlet ID	Outlet Name	Distributor Code	Distributor name
111	Outlet A	1	DIST A
112	Outlet B	2	DIST B
113	Outlet C	2	DIST B
114	Outlet D	3	DIST C
115	Outlet E	3	DIST C
116	Outlet F	1	DIST A

Customer/Distributor Table
Customer Code	Customer Name	Distributor Code
UG347	Customer1	2
KE328	Customer2	3
TZ782	Customer3	3
ET328	Customer4	1
CM237	Customer5	2

[v-yuaj-msft · Accepted solution]

Hi @Kaskazi_Network ，

Based on your description, you can do some steps as follows.

1. Create a many-to-many relationship between two tables.

1. Create a table visual. (Choose “count(distinct)”)

Result:

Hope that's what you were looking for.

Best Regards,

Yuna

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

[amitchandak]

@Kaskazi_Network , you can create a many to many join on distributor code.

There is an option of bridge table distributor code, but I doubt that will serve the purpose here https://www.seerinteractive.com/blog/join-many-many-power-bi/