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
1 ACCEPTED SOLUTION
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.
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.
