Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Ash187
Frequent Visitor

Using many to 1 relationship to display multiple records from both tables based on slicer

I have two tables, each row record has a ID, VendorName and a count.

 

ID1        COUNT1   Vendor

1            11             X

2             12            Y 

3              13           Z

4

...

1              11           E 

2              12           F

 

and  another table 

ID2  COUNT1  Vendor

1      11                 E    

2      12                 F

...

1       11                L

2        12               M
IDT = DISTINCT(UNION(SELECTCOLUMNS(Table1,"ID",Table1[ID1]),SELECTCOLUMNS(Table13,"ID",Table13[ID2]) ))

Since there were common multiple ID(s) in each table, I created a unique table of ID(s) from both tables.

Then linked each of the two tables through their ID(s) to this table with a many to 1 relaionship, with the cross filter direction from this table to  each of two tables.

 

Now I set up a slicer on the ID table. What I would like to is to get all records from either table 1 or table 13 based on the ID selected. By default, it should display all records in a table with no ID selected. How should I proceed ? 

 

Thanks

 

1 REPLY 1
amitchandak
Super User
Super User

What is the issue you facing while doing so

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors