Forum Discussion

reetu_k's avatar
reetu_k
Microsoft Employee
7 years ago

Ambigious Error - Help Needed

I am trying to build relationship that will allow select Date and Top Scenarios in my report. While the Date table relationships are working fine. But I am not able to replicate the same with Top Scenarios saying I am creating Ambigious paths - See my model and error below

 

 

 

Error

Need Help

1 Reply

  • edhans's avatar
    edhans
    Community Champion
    7 years ago

    I don't understand how you have a releationship with the Date table and the Aggregated Top Scenario table. There appears to be no date in there.

     

    It seems your problem is you have a bunch of many to many relationships. Relationships from the date table need to be 1 (date) to many (fact tables), not many to many. So DAX is not able to figure out how the filters are to flow over the relationships.