Forum Discussion
Data model relations not working properly in power pivot
If you have nothing in Values, PivotTable performs Full Outer join, i.e. all to all. As soon as you add any value relationships work.
It sounds like the issue stems from how Power Pivot handles relationships, especially when dealing with duplicates. Even though your unique customer ID table is correctly linked to the duplicate-rich preferences table, incorrect results can happen if the relationship isn’t set as one-to-many or if the filtering direction isn’t from the unique table to the duplicate one. In your case, using customer IDs from the unique table and pulling in preferences like "http://puredesifoods.com/" from the duplicates table should work—just ensure the relationship is properly configured. Power BI might auto-correct some of these relationship issues, but Power Pivot needs manual accuracy.
jackjoxon , that's not the case here. You may check the file, all relationships are correctly defined. The case is PivotTable need to have some aggregation.