Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Using Inactive Relationship to Fill Gaps in Data

Hello Everyone,   I am trying to use an inactive relationship to fill gaps in my data. I have a fact table and a dimension table. There are two relationships, 1 active and 1 inactive, pictured belo...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

I tried it, and I was unable to use COALESCE so I just used ISBLANK instead. This is what happened when I tried it: 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I changed my data table titles to match your use of them 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous,

    For your scenario, I think it may cause the 'circular dependency' reference issue due to the two relationships(activated and inactivated) mapping conflict.

    In my opinion, I'd like to suggest you use all functions to ignore the filter and manually apply the filter to your expressions, it may avoid the 'circular dependency' issue.

    Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT 
    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      how so?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Anonymous,

        Can please share a pbix file with some dummy data with a similar data structure as the raw table structures? It should help us clarify your scenario and test to coding formula.

        How to Get Your Question Answered Quickly 

        Regards,

        Xiaoxin Sheng