data model / power pivot relationships not working

[Zedders12345]

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

[AlexisOlson · 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.