Forum Discussion
Filtering issues when using inactive relationship to calculate measure
Right now I have 3 tables: 1. Stock Data - a list of stocks, the week they were purchased, a boolean field to indicate whether they have been sold, and if true, the week they were sold 2. Stock...
Can you share what the relationships between your table and confirm which value of WEEK your using in your tables.
In Week 3 Stock P does not show up in both tables so I'm guessing you have a bi-directionalal relationship so its cross filtering and since you have no trades in that week PowerBI is filtering it out. Try chaning the cross filter from BOTH to Single and be sure your using the WEEK from your bridge table in your slicer.
In Week 4 E is in both.