Forum Discussion

PowerWhy's avatar
PowerWhy
Helper IV
1 year ago
Solved

Ambiguous 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...
Need Help
  • PowerWhy's avatar
    PowerWhy
    1 year ago

    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.

PowerWhy's avatar
PowerWhy
Helper IV
1 year ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi speedramps,

    I'm glad you were able to solve your issue. As you mentioned you achieved the desired result by using the "IN VALUES" functions inside CALCULATE function, can you kindly mark the helpful reply as solution so that other community members having similar issue can get the solution quickly.

     

    Best Regards,

    Hammad.