PowerPivot Relationship Trouble RRS feed

  • Question

  • I'm having trouble getting started with relationships in PowerPivot.  I've created a dimension table and a fact table and put those in the data model.  I linked the many-to-one relationship, but when I create the Pivot table and drag in fields from the dimension and the fact table, the summed dollar values from the dimension table are always displayed as totals.  I expect them to be filtered by the dimension attributes.  Perhaps someone can point me to a simple example or perhaps someone is aware of a bug or common issue that I'm missing.  If I could post attachments here I would love to share and get your thoughts on where I'm going wrong.
    Thursday, January 22, 2015 4:36 PM


  • Potentially a quick solution is that you have your relationship the wrong way round.  Check that the arrow is pointing from your Fact table to you Dimension table and not the other way round.

    Friday, January 23, 2015 3:03 PM