Forum Discussion
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...
I changed my data table titles to match your use of them
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