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.
Just to make sure there is no doubt about what I meant: you can combine the data in one single table in the model, without modifying the underlying source.
I recommend you take a look into this.
Thanx for your patience with me as I learn this all.
Will look into your suggestion
Once again thanx to all who contributed.