Forum Discussion
PowerWhy
Helper IV
Helper IVAmbiguous filter
Hi, I am getting the amiguity error below if I try to make the relationship between drivers and cars active. I want both filter paths to work like an AND statement on the Cars table. Only if both...
Thank you all, I appreciate the ideal answer is to rebuild the backend but this is an minor edit on a large legacy product therefore I won't be able to achieve an acceptable ROI on a rebuild. In the end I achieved the desired result by using the "IN VALUES" functions within a CALCULATE function. I'll mark this as the answer as it did achieve the desired result within the limited context of not rebuilding the backend.
danextian
Super User
Super UserHi PowerWhy
If you activate that relationship, it will create ambiguity because there will be two active paths connecting Gender to Cars:
- Gender -> Drivers -> Cars (what you're trying to activate)
- Gender -> Codrivers -> Cars
When both paths are active, Power BI won’t know which one to use for filtering or calculations, which can cause confusion and lead to incorrect results.