Forum Discussion
DAX Summarize
As mentioned before, you have bi-directional filtering between your Date table and your other (fact) tables. This is why you cannot activate the relationship between these tables and your Senders tables.
Furthermore, as I guessed before, your tables all have the same structure and represent segments of your data.
I highly recommend you combine these data from different worksheets and different workbooks into one single table. Make sure you add an additional column for the sender's name.
This link will get you started:
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-combine-binaries/
This will greatly reduce the number of tables in your model, and its complexity overall.
Let us know, if you need further help with that task.
That's strange. You must have other relationships introducing ambiguity in the model.
Can you share the model or send us a screenshot of your relationship view ?
The only other relatonship in the model is a Date field coming from a seperate Date table