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.
Received a reply asking if I had a solution to my question - Yes and No.
I am able to get the table with all entries but I can't make it establish all the relationships with all the other tables. Still need that.
Hi GuyJohnson
You can either use Power query as suggested above (referencing queries, deleting the useless columns and remove duplicates in the senders column) or DAX to create a new table.
If you opt for DAX solution, you should go to Modeling > New Table and then:
DsctSenders = Distinct( Table[Sender] )
Your Table can be any table of your model. For performance issue (distinct is an iterator, it iterates over each row of the table) choose the smallest table (e.g with the lowest number of rows but of course make sure it contains all the 'Senders' you need!).
You now have a brand New Table called DsctSenders with a single column containing the unique values of [Sender]. You can link it to the other tables of your model.
Does not work for creating the relationships. I get this:
You can't create a direct relationship between Senders (My Table name) and Senders 2015 (Table with some of the names) because that would introduce ambiguity between tables Senders 2015 and Senders 2016. To make this relationship active, deactivate or delete one of the relationships between Senders 2015 and Senders 2016.
I don't have any relationships between those tables that are showing up. They are only in the 2 tables I created via the above posts.
I'm confused????
This error message is due to using bi-directional filtering in your model.
This comes with a few restrictions:
https://msdn.microsoft.com/en-us/library/mt591991.aspx
In your case, it may make sense to only use one-way filtering.
Also, you said you had two tables named 'Senders 2015', and 'Senders 2016'. Do these tables share the same structure? In that case, you may want to use "Append Queries" in the query editor, so you only have one table containing all your data for 2015 and 2016.
This would be another way to solve your issue.
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