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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
froelichgr
Advocate I
Advocate I

filtering multiple dimension tables

I feel like this should be a basic question, but I can't get my head around it.  I'm trying to filter multiple dimension tables that have a common field.    Example I have 2 dimension tables (Employee and Orders).  Both Employees and Orders have a column of Division.   

 

Employee and Order are not related, but there are employee transactions for each order.  So if I use the Division table as a bridge, it creates ambiguity for the transactions.  How would I go about filtering out Employees and Orders by Division?

 

 

froelichgr_0-1633538140915.png

 

 

  

3 REPLIES 3
amitchandak
Super User
Super User

@froelichgr , Ideally you should merge employee and division and use that as dimension

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

My problem with that is the Mfg Orders don't have a relationship with employee

Did you manage to solve this? I have the same issue

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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