Related Tables in PowerPivot
Here is an important note to self: if you use related table in PowerPivot, make sure you use the key from the satellite table, not the one from the facts. Even better, hide the key column in the facts to prevent yourself from spending a lot of time with wrong calculations!
