Forum Discussion
Solved
PivotTable Error with Relationships using Data Model
Hi guys, I have these 2 related tables by the CodEjeEstrategico field: What I need to get is this PivotTable result: However, all of the data of the Table1 is repeated in every row of...
Most probably for you data like in this model
rows selected as
What to do is to add one more column into main table with related fielld
and make Pivot Table on it
or simply land the table back into the sheet with DAX expression like
(Data->Existing Connections->Open Table 1, right click on it, Table->Edit DAX->select DAX).
See in attached
I expect you have the relationship in the wrong direction. Where it currently shows a 1 (left-hand side of the arrow) it should show the * and vice versa.