Forum Discussion
PivotTable Error with Relationships using Data Model
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
Hi all,
I have a similar issue as the one that has opened this post.
However, in my case, it is not possible to create a RELATED column,because entities are linked by date, and a more complex network of relationships.
I am having the same issue of getting a Pivot Table with repeated labels, that do not belong to the specific headings.
This is the relationships diagram:
Bellow, the relationship list:
This are the fields I am using to generate the Pivot Table from the Data Model:
And this is the pivot table I get as a result, where lots of entries appear as blank in a category where they don't even exist (all labels in that column appear repeted inside every single level from the previous category):