Forum Discussion
data model / power pivot relationships not working
Hi I have built relationships between my data tables in power pivot. I have tried to avoid many to many relationships by connecting everything to a unique look up value table. All relationshsips say they are active yet when i try and drag and drop field from different table into a pivot table it suggest that there are NO relationships.
Upon clicking manage relationships i can see they are all still active
As you can see im just left with a useless value. Someone please help me !!
Many thanks
In your relationship diagram, the LookUpTable filters all the other tables but not the other way around, so the Count of LookUpTable[BP] is unaffected by any other table values.
That's why it isn't working, but I don't understand enough about your data and what you're trying to do to suggest a solution.
1 Reply
In your relationship diagram, the LookUpTable filters all the other tables but not the other way around, so the Count of LookUpTable[BP] is unaffected by any other table values.
That's why it isn't working, but I don't understand enough about your data and what you're trying to do to suggest a solution.