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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi PowerWhy,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like while creating relationships you are getting ambiguity errors. As danextian and speedramps both responded to your issue, kindly go through their responses and check if your issue is resolved.

 

I would also take a moment to thank danextian and speedramps for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team