Forum Discussion
In Power Pivot, rows with erroneous data appear
Hi PaiYa
Power Pivot in Excel and Power BI do indeed handle relationships and data modeling differently, which can lead to the behavior you're observing.
In Power Pivot, when you place SalespersonName and ProductID in the Rows area, it might show all Product IDs under each Salesperson if there are no fields in the Values area to enforce the relationships. This happens because Power Pivot performs a full outer join, displaying all possible combinations of Salesperson and Product ID.
To ensure that only the relevant Product IDs appear under each Salesperson, you need to use measure or field in the value field.
Hope this helps!!
If this solved your problem, please accept it as a solution and kudos!!
Best Regards,
Shahariar Hafiz
Hi PaiYa
Power Pivot in Excel and Power BI do indeed handle relationships and data modeling differently, which can lead to the behavior you're observing.
In Power Pivot, when you place SalespersonName and ProductID in the Rows area, it might show all Product IDs under each Salesperson if there are no fields in the Values area to enforce the relationships. This happens because Power Pivot performs a full outer join, displaying all possible combinations of Salesperson and Product ID.
To ensure that only the relevant Product IDs appear under each Salesperson, you need to use measure or field in the value field.
Hope this helps!!
If this solved your problem, please accept it as a solution and kudos!!
Best Regards,
Shahariar Hafiz