Forum Discussion
Filter issue w/Measure
- 6 years ago
Hi Anonymous (Rena),
The table Team Target exists in a 1-* relationship w/the SprintCompletion table and the join is on the column Team name. The filter is a one way filter from Team Target to Sprint Completion. I cannot make this bi-directional because that would introduce complications with other tables (according to BI). The incorrect results look like this:
The number 996 represents the sum of all of the Team's target values which implies I'm not filtering correctly.
Since I needed this fixed right away, I forced the issue by creating a reference dupe of Sprint Completion (w/only the columns I really need) and related it to Team Target and also to the original Sprint Completion. I was then able to set Team Target and the new Sprint Completion Table in a bi directional filter relationship. I now get the expected results using the Team name from the new Sprint Completion table.