Forum Discussion

Humberto_Herrera's avatar
Humberto_Herrera
Copper Contributor
Jan 21, 2019
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...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Jan 21, 2019

    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

Humberto_Herrera's avatar
Humberto_Herrera
Copper Contributor
Jan 21, 2019

Hi Jan,

Thanks for answering. In this case, the relationship is ok, given that one record or the table1 could be related with one or more than one record of the table 2, and by the way, it is the Excel that makes that kind of relation.

JKPieterse's avatar
JKPieterse
Silver Contributor
Jan 21, 2019
Without (a sample of) your data this is very hard to answer.
  • Humberto_Herrera's avatar
    Humberto_Herrera
    Copper Contributor
    Jan 22, 2019

    Hi Jan,

    Thanks for your time.

     

    I attached the data in the initial post.

Resources