Forum Discussion
Post PatronAmbiguity Between Tables
Community ChampionFrom what I can tell you need an inactive relationship. Then combine a USERELTIONSHIP with a CROSSFILTER to turn on the relationship between Date and Projects and turn off the relationship between Date and Progress.
Give it a try and let me know if you need any help.
/ J
Post PatronWhat do you mean by combine them?
- tex628
Example:
Lets say you have these relationships:
Date <-> Project
Date <-> Progress
If you try to calculate progress by filtering Project[ProjectDate] what will happen is that the filter you put on Date[Date] will filter the progress table twice:
Date -> Project -> Progress
Date -> Progress
So what you would do is something along the lines of this:Measure = CALCULATE( [Progress] , CROSSFILTER( Date[Date] , Progress[ProgressDate] , NONE ) , USERELATIONSHIP( Date[Date] , Project[ProjectDate] ))
What this does is inactivate the relationship between date and progress while activiating the other one. Allowing you to do the [Progress] calculation with the correct relationship active.
I hope this shredded some light on what I'm thinking.
/ J 
v-xuding-msftCommunity Support
Hi paulfink ,
Your situation is introduced in the document: Adjusting Cross filter direction for a complex set of tables and relationships. And you could reference thess ones: Bi-directional relationship guidance and Active vs inactive relationship guidance to modify your model.
- v-xuding-msft
Hi paulfink ,
Can you please accept the helpful answers as solution? If you have resolved it by yourself, welcome to share it with us. More people will benefit from this thread. Thanks!