Forum Discussion
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 Sce...
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.