Forum Discussion
Assistance with PowerPivot Data Relational Models.
Hi Everyone:)
This is quite basic , I seem to have missed the basic idea I guess....
I have two tables:
The first contains both fields:
Table1 :
["Name", ]["Address"].
The second table
Table2 :
["Address"],["Area"}
The Address field is identical in both tables.
I am trying to create a Pivot table that contains "Name","Address","Area".
I am using PowerPivot, I have added both tables to DataModel and created a relationship between both "Address" fields and yet it doesn't seem to work. I tried both directions.
May I have your assistance please?
Thank you so much
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.
6 Replies
Hi Coral,
Hard to say what exactly doesn't work without the sample. Here is my one. Creating the PivotTable if you use Data model as source
the result is like this
Please see attached.
Hi and Thank you so much for your comment.
I was attempting to create a table that contains "Name" "Address" and "Area"
The problem is that it doesn't connect in the right way and I get a table with all the areas.
I attach a picture showing the table I receive.
Thank you so much again.
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
