Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Multiple fact tables for the same dimensions in tabular

Hi, im making a tabular model to use in Power BI and i have more than one fact table related, (Orders, sales, shippings) and all the tables are related to the Client, Items, Calendar dimensions but I...
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
8 years ago

Anonymous  it will be easier to understand how to help you if you provide more information.

 

what exactly do you want to do that you are not able to do?  can you show me what your relationship view looks like, it sounds to me like maybe something else is going on please screen shot your relationship view

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hello vanessafvg, thanks for your answer, below I attach an image of my tabular model. I can correctly analyze each of the fact tables separately using the dimension tables but I am having problems when using the non-active relationships cause I am not able to relate Shipments with Sales that are linked through Deliveries by two non-active relationships . How can i do this?

    Tabular model
    Am I using the DAX USERELATIONSHIP function correctly?
    Shipment Date = CALCULATE(MAX(Shipments[dt-embarque]);USERELATIONSHIP(Shipments[nr-embarque];Delivery[nr-embarque]))

     

    Thanks for you collaboration :)

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Same problem here. Have you found a solution since?