Forum Discussion
Solved
Filter visual based on an inactive relationship
I have a number of measures that take inactive relationships into account when it comes to dates. I have one "Calendar" table that is linked to many date columns, inactively, and the measures just ca...
- are you able to share your model or some dummy data.
you are doing a count therefore you are using a measure, you need to calculate that count with the userelationship() function which will force the inactive relationship to be counted with the correct date.
this is a good article that goes through a few scenarios
https://www.sqlbi.com/articles/userelationship-in-calculated-columns/
Disclaimer: I know this isn't an efficient solution and it isn't feasible with large datasets, but I couldn't come up with anything better 🤔
abcd, I was able to avoid this ambiguity issue by just making a duplicate query of my target table (e.g. "employeeAssements" in your example)... then I can have an active relationship with the duplicate without worrying about ambiguity