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
SniperPro
Frequent Visitor

Modelling many relations on powerbi desktop

Hello,
I have bellow tables on PowerBI desktop, I want to relate the Account table to the event table without passing by the Opportunity table (the account in the event isn't the same as in the opportunity). The Account is very large so I don't want to duplicate it.
I would like also to relate the case table to the Event table, the relation is 1:Case -> n: Event.
What is the best way to model that on powerbi desktop.

SniperPro_0-1680988421088.png

 


 

2 REPLIES 2
amitchandak
Super User
Super User

@SniperPro , If want an opportunity as a dimension, then you can directly connect it . And remove join

 

then you can use this method to filter measure and slicer of opportunity

 

How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8

 

 

Other wise , two copies of opportunity - one as fact and another 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

@amitchandak 
Thank you for you reply. 
How can I modify the Control Measure to filter slicer in both way ? In your example I want to use the same Contol City Measure to filter the Cities when I chose a Customer.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

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!

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