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
Adidas
Helper I
Helper I

Combining few Fact tables with two dimensions

Hello

I'm trying to build a 'control center' page where multiple measures from multiple fact tables are presented in Cards.

1. this page will have two slicers based on two dim tables

2. No measure is combining more than one fact table.

 

when establishing the relationships in the model, power bi forced some of them to become inactive.

1. what is the reason for that restriction, I can't see the ambiguity?

2. how can I overcome this limitation?

again, No need to any combined measures, Just slicing all the cards by common slicer

this is the desires structure

thanks

Structure.JPG

 

1 REPLY 1
Mariusz
Community Champion
Community Champion

 Hi @Adidas 

Can you send a screenshot of your model?

 

Best Regards,
Mariusz

Please feel free to connect with me.
Mariusz Repczynski

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors