Forum Discussion
Solved
Circular dependency blocks cross filter
I have a small issue here that hopefully can be resolved. Now, we have three tables: Agent reports is supposed to be the "centralizer" that connects to all other tables. It is a summarization bas...
Oh, nevermind, I found out how.
For those in the same problem, my solution is this:
When wishing to compare the value from agent score with the target in the other table I used this formula in a measure:CALCULATE(max('Operational Objectives'[NRW AG.]),CROSSFILTER('Agent report'[Join Key Obj],'Operational Objectives'[Join Key Obj],Both))
The crossfilter function seems to not have the same limitations as the relationship and this formula brings the equivalent column in Op Obj for which that join key works
Oh, nevermind, I found out how.
For those in the same problem, my solution is this:
When wishing to compare the value from agent score with the target in the other table I used this formula in a measure:
CALCULATE(max('Operational Objectives'[NRW AG.]),CROSSFILTER('Agent report'[Join Key Obj],'Operational Objectives'[Join Key Obj],Both))
The crossfilter function seems to not have the same limitations as the relationship and this formula brings the equivalent column in Op Obj for which that join key works
The crossfilter function seems to not have the same limitations as the relationship and this formula brings the equivalent column in Op Obj for which that join key works