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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AmrutaKar
Frequent Visitor

Search Data betwenn 2 tables that have manay to many relationship

I have 3 tables.

1) Customer Table

2) Accounts Tabble

3) Customer_Accounts Table

 

One customer could have many accounts and simmilarly One account could have multiple customers. for eg

Customer Table

customerIDcustomerName
1A
2B
3C

 

Accounts Table

accountIDaccountName
4ABC
5DEF
6GHI

 

Customer_Account Table

customeraccountidcustomerIDaccountID
114
215
326
436

 

There is a  relationship between Customer Table , Accounts Table and Customer_Account_Table.

I have to create a dashboard where if I search for customer in the customer table, I should get the Accounts it belongs to from the Accounts table and simmilarly, if I search for Accounts in the Accounts table , I should get all the customers that belong to that account.

Could you please tell me how can I achieve this.

 

Thanks

1 ACCEPTED SOLUTION
Jimmy801
Community Champion
Community Champion

Hello @AmrutaKar 

 

you have to set the cross filter direction to "both"

grafik.pnggrafik.png

 


If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

View solution in original post

1 REPLY 1
Jimmy801
Community Champion
Community Champion

Hello @AmrutaKar 

 

you have to set the cross filter direction to "both"

grafik.pnggrafik.png

 


If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors