how to proceed if many to many relationships exist?

[John2]

I have a table called patches which has many fields like computer name, id, patch name etc.

I have another table called grps wherein I have computer name and computer groups. I want to add the computer group to a slicer so that it affects the visuals. But since grps has multiple values of computer name, the relationship of many to many comes into picture. what can I do here?
grps table: 

Computer name	Computer Group
ubuntu	server1
ubuntu	server2
ubuntu	server3
test1	server1
test1	server2
test1	server3
test1	server4
test1	server5
pc-1	server1
pc-1	server2
pc-1	server3

[John2]

I tried making dimension table of computer groups but since every computer name is present in 2-3 groups, when I try to merge the tables error occurs. What to do then?
My end goal is that when I put computer group as a slicer and select group 1, the visuals should select all the computer names in a given group, i.e. if group 1 contains names A,B,C,D; all data of these computers should be shown.

[BITomS]

Hi @John2 

It sounds like both patches and grps tables are fact tables? In this scenario, it sounds like the creation of a computer group dimension table is required. This dimension table would only have the distinct entries of computer groups and you could then join this table to the relevant columns in your patches and grps tables respectively. You can then use the column from the dimension table in your slicer.

You can read up on fact, dimension tables and star schemas here: https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

Hope this helps.