Forum Discussion
Assistance with PowerPivot Data Relational Models.
Without that you pivot nothing and, in general, you don't need the pivot table. From data table you may combine one more table with all information.
Data->Existing connections, select Table1 and open. Right click on it, Table->Edit DAX. Here select DAX
and into expression put something like
EVALUATE SUMMARIZE ( Table1, Table1[Name], Table1[Address], Table2[Area] )Result is
Please see attached.
I just noticed that I get the desired table only if I add a column of "count of name" or "count of address". I don't want that column and I don't understand why am I obliged to add it.
I attach a photo.
Thank you
Without that you pivot nothing and, in general, you don't need the pivot table. From data table you may combine one more table with all information.
Data->Existing connections, select Table1 and open. Right click on it, Table->Edit DAX. Here select DAX
and into expression put something like
EVALUATE
SUMMARIZE (
Table1,
Table1[Name],
Table1[Address],
Table2[Area]
)
Result is
Please see attached.
Even better
Evaluate ADDCOLUMNS ( Table1, "Area", RELATED ( 'Table2'[Area] ) )Thank you so much for your help!