Forum Discussion
Solved
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 sa...
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.
AlexisOlson
Super User
Super UserIn 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.