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.
Thanx - will research Power Query
Power Query won't help you with relationships ambiguity but just to obtain a table with the unique values of [Sender] (Which you already have now, right?).
It is a question of data modelling. Please share the model or your relationships view through a screenshot so we better understand the issue.
Thanks
To everyone who has been assisting with this issue I’m having thanx. All replies have helped and I have learned something from all of them.
Let me restate the problem and attach a screen shot of my relationships. This way we can all get on the same page.
I have an Excel Spreadsheet that has numerous tabs on it that track checks we receive for various areas within the company. Each sheet in the Spreadsheet is named by year. I brought the Spreadsheet into Power BI desktop along with a separate Date table. The Date table is a standard one I’ve used successfully many times to allow me to slice my data by data.
My issue started when I tried to take the column named Company Sending Check from each Sheet on the Spreadsheet. The sheets are named Alpont 2010, Alpont 2011, etc. That column does not contain all the Companies so I needed a table to list all names so I could slice by company.
paulagwas very helpful to show me how to get this table and it worked – but it won’t establish the relationships I need. This is table Alpont Reference
Datatouillesuggested another way to get my table and it also was very useful – but again it won’t establish my relationships. This is table Alpont Senders
Currently I have a relationship from the Date table to each of the other tables between the dates and it works for slicing on dates.
When I try to establish relationships, I get what is in the screen shot.
He arrows going off the page(screenshot) are to other sheets on the Spreadsheet that contain similar but different data that I haven’t started to work with. The relationships there are Date only.
Where am I going wrong???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.
I got things working once I recreated the relationships correctly.
I'm unable to combine the Data as the department wants it kept in seperate shets in the Spreadsheet - I can work on that.
Everyone has been very helpful and I've learned alot.