• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

POWER PIVOT

M

martinargimon

Member
HI chandoo.
My Pivot table does NOT bring up the 'unique' data that corresponds with my filter
In the attched file you'll see under the 'Invoices' sheet, a pivot table that attempts to bring and combine data from two tables. The link ( relationship ) is correct though. In this 'Rental Property" database, I want to combine the Lease Number with the Tenant ID and from the 'Tenants' Table , i want to bring across the last and first name, but unfortunately it lists ALL the Last Names , rather than the one 'specifically' selected. NOT sure what is that i am doing wrong?. I 'd appreciate your help? . Thanksing you in advance. regards Martin
 

Attachments

  • CMA Realty LMV Database Program-Current.xlsm
    848.4 KB · Views: 4
Well... you don't have any value field to evaluate.

Just add some field from T_Leases in Value field (Ex: Count of Agent etc).

Have a read of related topic discussed in link. Specifically Post#11 to 17.

Power Pivot Relationships failed

I have two tables, one employee and the other with the categories. I’ve created the relationships between them through the Id category field, and I can’t find the reason why it doesn’t work. I’m using Excel 2016. It’s a very simple thing but I can’t find the error. Attached the file. Thanks a lot.
chandoo.org
 
HI Chihiro. Thanks a lot ! it works like you say. Which text book can i read to understand this issue of Fact and dimension tables. ? Although your suggestion works , I still do not understand what is the problem , and i would like to read more to avoid making these mistakes in the future. Thanks so much. Kind Regards . Martin
 
Go read up the link I gave you. It discusses in detail what caused this issue.
As for difference between Fact vs Dimension tables... see links.
builtin.com

Fact Table vs. Dimension Table: What’s the Difference? | Built In

A fact table contains the primary keys of a referenced dimension table, and the dimension table contains the descriptive information. They make up the key components in star schema.
builtin.com builtin.com
learn.microsoft.com

Understand star schema and the importance for Power BI - Power BI

Understand a star schema and its relevance to developing Power BI data models optimized for performance and usability.
learn.microsoft.com
 
You must log in or register to reply here.
Back
Top