Ambigious Error - Help Needed

[reetu_k]

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

[edhans]

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.