Power pivot data relationship

Copper Contributor



All row items (both columns) are repeating when bringing 2 categorical columns from 2 different tables into row field in pivot table through power pivot one-on-many relationship.

How to fix this?


Thanks in advance.

1 Reply


Could you please give bit more details or at least screenshot how model is built and what do you pivot.