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

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