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

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      How do I add a file? I have a pbix, but I don't see an option to share it?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        HI Anonymous,

        You can upload your file to onedrive for business and share the link here.

        Notice: do not attach sensitive in the sample file.

        Regards,

        Xiaoxin Sheng