Home Forums Power BI relationship between two tables in power pivot data model

This topic contains 3 replies, has 3 voices, and was last updated by  infinitex86 4 months ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #10183

    sailaja
    Participant
    • Started: 2
    • Replies: 1
    • Total: 3

    Is it possible to have over one active relationship between two tables in power pivot data model?

    #10437

    m3tr01d
    Participant
    • Started: 0
    • Replies: 17
    • Total: 17

    Hi,

    I’m not a Pro but I don’t think it is possible. If you can explain what your tables looks like, we can see if we can do a modification to your data model 🙂

    Most of the time, this situation happen with a Fact table contaning 2-3 different dates (like a Sales table) with a relation to a date table.

    #10644

    sailaja
    Participant
    • Started: 2
    • Replies: 1
    • Total: 3

    Hi, Thank For Your Replay

    #10647

    infinitex86
    Participant
    • Started: 3
    • Replies: 9
    • Total: 12

    I don’t believe there’s a way to have more than 1 *active* relationship, but you can always have an inactive relationship and then specify which relationship you want using the USERELATIONSHIP() function.

    Documentation can be found here:

    https://msdn.microsoft.com/en-us/query-bi/dax/userelationship-function-dax

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.