Context in pivot table when row is foreign key RRS feed

  • Question

  • Can anyone explain the logic to me as to why the context for a pivot table row having a foreign key from a fact table on the row, includes the entire dimension table?

    My objective is to summarise the the fact table and to bring the description from the dim table, based on the join between the foreign and primary keys.


    I expected the pivot context to deliver a single value from the dim table because of the join.  Instead, I get every record in the dim table.  Can anyone please explain why? 

    Friday, June 21, 2019 3:18 AM

All replies

  • This might be caused by non matching keys. Different formats are often the cause for such a behaviour.

    Next time, please post in the appropriate forum. This is the Power Query forum and your question is around the data model, which would rather fit into the Power Pivot forum (https://social.technet.microsoft.com/Forums/en-US/home?forum=sqlkjpowerpivotforexcel ).

    Imke Feldmann - MVP Data Platform (PowerBI) - http://www.TheBIccountant.com 

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful - Thanks!

    Saturday, June 22, 2019 3:29 AM
  • The keys match.  I confirmed this by using Related in a calculated column.  So, that is not the problem.  But anyway, I know you are an M person so I'll try the other forum.

    Saturday, June 22, 2019 7:19 AM