Forum Discussion

Adidas's avatar
Adidas
Icon for Helper I rankHelper I
7 years ago

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

 

1 Reply

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion

     Hi Adidas 

    Can you send a screenshot of your model?

     

    Best Regards,
    Mariusz

    Please feel free to connect with me.
    Mariusz Repczynski