Forum Discussion

hanyfouda2023's avatar
hanyfouda2023
Helper II
3 years ago
Solved

Ambiguity issue

Dear Helpers,

I have an issue need support , here is the case

I have Calendar lookup table, Customer lookup table & Sales , Returns tables

I make relationship between Calendar lookup table & Sales , Returns table

When I try to make relationship between Calendar lookup & Customer table it says there is ambiguity issue I have to deativate relationships wirh calendar lookup tables to activate this relationship

For your support

Thanks

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi hanyfouda2023 ,

     

    Please check your data model if your relationship map contains multiple active relationships to analytic summarize, it will confused which one should be the right one. So it only allow one activated major relationship link between linked tables for analytics and interactions.

    For refernece:

    Understanding Ambiguity in Power BI Data Model.

    If this reply still couldn't help you solve your issue, please share a screenshot with your relationship.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    hanyfouda2023 , Make sure are join are single directional and 1-M from dimension to fact. Seem like an issue because of multiple paths or loops

    • hanyfouda2023's avatar
      hanyfouda2023
      Helper II
      3 years ago

      Dear Amitchandak,

      Thanks for your answer , I revisit all relationships & its ok only 1-M ,single path not both plus all tables connected from domension to fact

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi hanyfouda2023 ,

     

    Please check your data model if your relationship map contains multiple active relationships to analytic summarize, it will confused which one should be the right one. So it only allow one activated major relationship link between linked tables for analytics and interactions.

    For refernece:

    Understanding Ambiguity in Power BI Data Model.

    If this reply still couldn't help you solve your issue, please share a screenshot with your relationship.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.