How To Filter Data in a Visual based on Column Values from another Visual

[anuraagmucherla]

I have below two tables:

Visual 1 - Table 1 (Permissions table)
Desc: Shows what permissions exist for each group)

CompanyFolder	Permission	Group
C1	RWX	GP-C1-Admin
C1	RWX	GP-C1-Developer
C1	R	GP-C1-Analyst
C2	RWX	GP-C2-Admin
C2	RWX	GP-C2-Developer
C2	R	GP-C2-Analyst

Visual 2 - Table 2 (GroupMember table)
Desc: Group-Member is Many-to-Many association. Each group can have multiple members. Each member can be part of multiple groups.

Group	Members
GP-C1-Admin	Scott
GP-C2-Admin	Scott
GP-C1-Developer	Tom
GP-C2-Developer	Tom
GP-C1-Analyst	Matt
GP-C2-Analyst	Matt
GP-C1-Developer	John

Question:
I have two visuals in my PowerBI report with each visual showing data from above tables. If I filter for a specific member in Visual 2, I want Visual 1 to reflect to show only those permissions that exists for the selected member.

Ex: Let's say I filter for "Scott" in Visual 2, I want Visual 1 to look like below:

Visual 2

Group	Members
GP-C1-Admin	Scott
GP-C2-Admin	Scott

Visual 1

CompanyFolder	Permission	Group
C1	RWX	GP-C1-Admin
C2	RWX	GP-C2-Admin

P.S.
Table 1->Table 2 is a many-to-many relationship. But I CANNOT JOIN them together to create a single view because the data is very huge (~1billion rows) and PowerBI is stuck during refresh if I do that.

Looking for alternative suggestions! (Can I apply drilldown or multi column filters on multi-visuals?)
Thanks in advance!

[amitchandak]

@anuraagmucherla , You need to create common dimensions and join both tables with them. And use those in visuals and filters. As the tables are big, better to bring those from the source.

Here is the DAX example

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...