Forum Discussion

SMaskery's avatar
SMaskery
Regular Visitor
1 year ago
Solved

Relationship ambiguity issue

Hi,

 

I have a data set structure as below:

 

I would like to create an additional relationship between the Plants table and the Process Steps table but I am unable to due to the error: 

 

But as far as I'm aware, due to the single direction of the relationships this shouldn't be an issue?

Any help would be greatly appreciated.

 

Need Help
  • SamWiseOwl's avatar
    SamWiseOwl
    1 year ago

    Hi SMaskery 

    The issue is HLQA Scores could be getting filtered from two different directions.

    Plants -> Defects -> HLQA Scores

    Plants -> Process steps -> Sub process steps -> HLQA Scores

     

    You can double click on the relationship and make one inactive:

     

     

    Then using DAX forumla turn the one you want back on for the measure:

    Activate relationship =
    CALCULATE(
        [Sum of Qty]
        ,USERELATIONSHIP(
            'calendar table'[Date]
            ,Sales[PaymentDate] --existing relationship
        )
    )

1 Reply

  • SamWiseOwl's avatar
    SamWiseOwl
    Super User
    1 year ago

    Hi SMaskery 

    The issue is HLQA Scores could be getting filtered from two different directions.

    Plants -> Defects -> HLQA Scores

    Plants -> Process steps -> Sub process steps -> HLQA Scores

     

    You can double click on the relationship and make one inactive:

     

     

    Then using DAX forumla turn the one you want back on for the measure:

    Activate relationship =
    CALCULATE(
        [Sum of Qty]
        ,USERELATIONSHIP(
            'calendar table'[Date]
            ,Sales[PaymentDate] --existing relationship
        )
    )